473,811 Members | 2,856 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

unicode character

1 New Member
I have a problem with unicode character, as i create a database in SQL Server 2005. I want to query from a table that criteria fields are contain unicode character i.e NVARCHAR.
e.g: SELECT * FROM tblMyTable WHERE MyField='ភាសាខ្ មែរ'. But when i did like this all rows that contain Unicode Character always display. it doesn't fit to my criteria i.e 'ភាសាខ្មែរ'

May someone help me please.
Jun 12 '11 #1
1 1454
!NoItAll
297 Contributor
I am not an expert - but I did have a similar problem until I set the collation for the database properly. It must be set for the character set you intend to use in this case Unicode. It's not clear, however, if your unicode is UTF8, UTF16, UTF32, etc.
Jun 14 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1444
by: Daewon YOON | last post by:
I learned from http://www.jorendorff.com/articles/unicode/python.html that one can specify a unicode character by u'\N {name of the character}'. Is there any method that I do the reverse of this process? For example, when I have a unicode character '£', uc.method() should return the character name 'POUND SIGN' in str format. -- zooy
5
5200
by: Michael | last post by:
I mean how to use _tprintf().
1
1666
by: Diego L. | last post by:
hi to all i need help urgently. I´m having a problem with the unicode character 0x2a2b29. I´m working with an xml document and when i try to read it i have this error message org.xml.sax.SAXException: Stopping after fatal error: An invalid XML character ( Unicode: 0x2a2b29) was found in the element content of the document. if i try to find this character in the text i don´t find nothing can somebody help me????
6
2794
by: dbaldi | last post by:
(this is follow-on message to one posted yesterday) I'm trying to reproduce the capabilities in both Notepad and Excel, whereby a Unicode text file with Unicode characters can be converted to ANSI, while still preserving the unicode characters within. Specifically, I'm using the unicode character &x2022, which is a largish bullet. I've tried this:
1
2300
by: lkrubner | last post by:
>Alan J. Flavell Oct 7 2004, 1:44 pm show options >>On Thu, 7 Oct 2004, Shmuel (Seymour J.) Metz wrote: >> at 08:24 PM, "Alan J. Flavell" <flav...@ph.gla.ac.uk> said: >> >I think you mean "multiple character encoding schemes". >> Yes, although a different character set would imply a different >> encoding scheme. > >Absolutely not. That's the whole point! > >In (X)HTML you can (if you so choose) represent any Unicode character
0
1729
by: Zengfa Gao | last post by:
Hi all, I try to put into some data I backuped. export PGPASSWORD=security cat /opt/myproj/bin/mysave | /usr/bin/psql -h localhost -U myuser DB_Name I got:
1
1901
by: Ryu | last post by:
Is there a way to get the convert a unicode character such as chinese characters to byes? Everytime when I use Convert.toByte I will always get a System.OverflowException "Value was either too big ot too small". Is it because unicode characters require 16 bits? In that case how to I convert the character to byes?
4
4260
by: Spencer H. Prue | last post by:
Hello, I am trying to print a unicode character that's in Japanese. In my ASP.NET app (C#) I just set a char to that unicode character and use a response.write(). The char prints, but it is just a square. I set the culture of the .aspx page to japanese, and even though my browser already prints asian characters, I added the Japanese to it also. My web config has the utf-8 line in it. What should I do? Thanks,
12
2614
by: JBJ | last post by:
Hi, I'am very newbie in Python. For the moment I'am trying to convert an unicode character to his uppercase unaccented character. By example with locale fr_FR: a,A,à,À should return A o,O,ô,Ô should return O ½,¼ should return ¼ i,I,î,Î should return I
0
1314
by: liveshell | last post by:
Hi all, In my application, I am reading a file and storing it in a array of character. That is ascii format...now in certain situation I get unicode character (or lets say junk character). I want to know that whether it is plain ascii or Unicode...How can I ?? Thanks, LiveShell
0
9722
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10393
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9200
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7664
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6882
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5690
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3863
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.