Hello Rhino,
I am not sure how familiar you are with the character set settings.
I am not using 3.xx versions anymore, but if I remember correctly they
only allow a limited control for setting character sets.
Your best guess might be the documentation that comes with your installation.
(Man pages, Info, Chapter 11 of the MySQL docs. etc.) You can view it also
online
http://dev.mysql.com/doc/mysql/en/Charset.html
but as this is the newest version, you will have to filter out what doesnt
apply to your version yet.
In order to be able to give you any advice you need to be more specific.
Which character sets are set now for the server and the client as default ?
Are the "foreign characters" in the same character set ?
Are you attempting to store the "foreign character" together with your
default characters in the same table / same DB ?
You may also read through my presentation "Using MySQL in a Japanese
environment" which can be found here
http://www.be-known-online.com/mysql
I am not sure if this really helps you, as I dont yet fully understand
were to start trouble shooting.
If you could be a bit more specific that would help a lot.
best regards
Nils Valentin
Tokyo/Japan
>
> ----- Original Message -----
> From: "MySQL" <[EMAIL PROTECTED]>
> To: "MySQL" <[EMAIL PROTECTED]>
> Sent: Sunday, September 05, 2004 2:05 AM
> Subject: Storing foreign characters in DB
>
>
> I'm having a problem figuring out how to deal with foreign characters in
> text that was copied from an MS Word document and pasted into a form
> field,
> then stored in a MySQL DB. (I have MySQL 3.23.58 running).
>
> I'm not how sure how these characters are being stored in the MySQL
> database, but, when I retrieve the text and run it through PHP's
> htmlentities() function, each foreign character is converted into 2 other
> foreign characters that don't at all represent the original.
>
> For example, a lowercase u with an umlat over it (? is somehow displayed
> as
> an uppercase A with an umlat over it followed by the 1/4 symbol after
> parsed
> by htmlentities(). A lowercase o with an ulmat displays as an uppercase A
> with an umlat over it followed by the paragraph symbol. It seems that the
> uppercase A w/umlat is a constant, and the next character changes.
>
> How are these foreign characters being stored in the DB? Do I need to do
> something in order to store these characters properly, or is this
> something
> I need to somehow do on the PHP side of things??
>
> ----------------------------------------------------------------------------
> ----------------------------------
>
> Have you looked at the manual, particularly the Localization and
> International Usage section at
> http://dev.mysql.com/doc/mysql/en/Localisation.html?
>
> Have you tried the MySQL archives (http://lists.mysql.com/) where this
> matter has been discussed?
>
> Rhino
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
