At 05:30 PM 5/4/04 +0100, you wrote:
Basically the best guess would be the documentation that comes with your download. Note that online documents at www.mysql.com are always a mixture of several documentation versions really.
Thats the problem. Yesterday, I downloaded 4.0.1x yet the documentation that comes with it in regards to asian character set etc. is 4.1
But the application I'm working with is a perl/cgi/mysql thing on a virtual hosted site and is using 4.0.15 (which means I can only set things from the application level or via the connection string.)
I need to know how to set this up for this version not 4.1
From your documentation I gather I need to tell the server what character set to use and also about data coming from and going to the client.
My problem is I'm not too sure how to start.
Here is the data flow:
Storing Data ------------
1. web page (uses shift_sjis) --> 2. cgi app captures form data with mixed fields eg. english and japanese 3. cgi app ---> saves data to mixed fields in a table.
Is there something I do at the point data is being saved. Save one field in one kind of encoding and the other in another kind of coding.
OR is there something I indicate by a property of the field
Retrieving Data --------------- 1. cgi app searches on varchar fields both japanese and in english 2. cgi app searchs on text fields using fulltext engine for keyword searches.
Everything works fine for the english but the searches in japanese are not working.
I'm thinking maybe it has something to do with the encoding in the japanese fields which I'm not sure how to do at the field level for version 4.0.15
Thanks
David J.
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.662 / Virus Database: 425 - Release Date: 4/20/04
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
