UCS2 question - MySQL Database

Simon

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Sorry if this is a stupid question.

I'm running BK MySQL 4.1.1alpha, and I'm trying to talk to a table with a=20
charset of UCS2. (I'm mixing hebrew and latin-1 characters in it, and it=20
seems the best way.) - I'm talking to it from a program I'm developing usin=
g=20
mysql++.

How am I supposed to enter the ucs2 characters into the SQL database? I can=
't=20
see that I can use the actual bytes in the SQL query, as I'll end up with=20
null characters in the data I send to the SQL server. How do I write an SQL=
=20
statement that contains UCS2 characters?

Thanks,
Simon

=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/Sz90PBt+tvwCnbYRAk1aAKCFFVlIEO/AfW67+4A93t/jfiu4lgCfd01F
HgshmrM15XYBVc+cC5ZmY50=3D
=3DTmit
=2D----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1

Subscribe Reply

1756

Similar topics

572

UCS2 question

by: Simon | last post by:

=2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Sorry if this is a stupid question. I'm running BK MySQL 4.1.1alpha, and I'm trying to talk to a table with a=20 charset of UCS2. (I'm...

MySQL Database

4994

Simple Java/XML question

by: Stevey | last post by:

I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>

.NET Framework

2626

ASP.NET 2.0 question on Partial Types with J.I.T.

by: nospam | last post by:

Ok, 3rd or is it the 4th time I have asked this question on Partial Types, so, since it seems to me that Partial Types is still in the design or development stages at Microsoft, I am going to ask...

.NET Framework

3055

Filling question ID automatically by using query or VBA

by: Ekqvist Marko | last post by:

Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...

Microsoft Access / VBA

7248

converting UCS2 character code to a string

by: PEACEMAKER | last post by:

I have a bunch of ucs2 character code reference numbers like 672c. Is there an easy way to convert these to a c# string so that when it is printed out in the appropriate font it displays the...

C# / C Sharp

4327

Convert HTML entities to Unicode UCS2? What to do?

by: Alexander.Veit | last post by:

Hallo, does anyone know how to convert HTML Entities into UCS2-String (Value). For example: I need to convert Sułowska 43 (value in mysql database) to a unicode string with the specified...

PHP

2697

Encode arabic Text to Ucs2 format

by: younus | last post by:

Hi Guys I need some help i want to encode arabic text to UCS2 format in asp my text بيسليسلسيس is converted to 0633062C064A06440643002006280646062C0627 this format plese help me this is very...

ASP / Active Server Pages

1528

How cani encode arabic text to UCs2 format

by: younus | last post by:

ASP / Active Server Pages

2207

ucs2 or ucs4?

by: Neal Becker | last post by:

How do I tell if my python-2.5 is build with ucs2 or ucs4?

Python

7131

What is ONU?

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,...

General

7007

Changing the language in Windows 10

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...

Windows Server

7174

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

6894

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

4600

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

3099

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

3091

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

665

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

297

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General