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 Post Reply

1752

Similar topics

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

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

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

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

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

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

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

How cani encode arabic text to UCs2 format

by: younus | last post by:

ASP / Active Server Pages

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

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware