Re: [PHP] storing japanese in mysql (or pgsql)
On Wed, 1 Oct 2003 09:10:05 -0700 Chris W. Parker [EMAIL PROTECTED] wrote: - Edwin - mailto:[EMAIL PROTECTED] on Tuesday, September 30, 2003 7:00 PM said: What exactly do you mean by extended characters? And, do you mean all *other* characters are inserted properly? Anyway,... I just mean the characters that you can't type unless you do something like alt-250, alt-145, etc. Hmm... these characters can be entered as #250; (for alt-250) and #145; (for alt-145) and this has nothing to do with your DB being able to handle Japanese characters... If they're not ujis (for euc-jp), add this to your my.cnf file:(Under [mysqld] and [client]) default-character-set = ujis I added that line to the [mysqld] section but there was no [client] section so i added the following. [client] default-character-set = ujis That's correct. Btw, check your php.ini as well and make sure that your settings under [mbstring] are correct. Each line in the [mbstring] section was commented out. So I uncommented them. I also uncommented the mbstring extension. Hmm... (sounds like you're on Windows) since I don't do Windows, I'm not really sure if that will work. Under Linux, for example, the extension should be compiled in... Anyway, just try it. If it doesn't work, maybe you need to grab a copy of a patched or compiled for Japanese version of php at http://www.php.gr.jp/project/i18n/ . (I don't think this is necessary though...) I'm just about to restart both servers, so we'll see what happens. Ok. - E - __ Do You Yahoo!? Yahoo! BB is Broadband by Yahoo! http://bb.yahoo.co.jp/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] storing japanese in mysql (or pgsql)
- Edwin - mailto:[EMAIL PROTECTED] on Tuesday, September 30, 2003 7:00 PM said: What exactly do you mean by extended characters? And, do you mean all *other* characters are inserted properly? Anyway,... I just mean the characters that you can't type unless you do something like alt-250, alt-145, etc. If they're not ujis (for euc-jp), add this to your my.cnf file: (Under [mysqld] and [client]) default-character-set = ujis I added that line to the [mysqld] section but there was no [client] section so i added the following. [client] default-character-set = ujis Btw, check your php.ini as well and make sure that your settings under [mbstring] are correct. Each line in the [mbstring] section was commented out. So I uncommented them. I also uncommented the mbstring extension. I'm just about to restart both servers, so we'll see what happens. Thanks, Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] storing japanese in mysql (or pgsql)
(I posted this to another list yesterday without response, so if it looks familiar, that's why.) Hi. I'm working on a small study aid for myself (and anyone else that wants to use it) and I could really use the ability to store Japanese characters in a MySQL or pgsql db. Right now I've created a very large array. What I'd like to do is have a form that will allow me to add new characters whenever needed. So far my attempts at this have failed. It always seems that the extended characters get turned into their html entity equivalents before they are inserted into the db. I'm using euc-jp as the character set. I'm pretty much lost with this. Anyone have experience with this that they'd like to share? (on or off list is fine.) Thanks, Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] storing japanese in mysql (or pgsql)
Not sure about mysql, but with pgsql, if you create your database with utf-8 or equivalent japanese encoding, you should be able to store japanese characters in the db... Chris W. Parker wrote: (I posted this to another list yesterday without response, so if it looks familiar, that's why.) Hi. I'm working on a small study aid for myself (and anyone else that wants to use it) and I could really use the ability to store Japanese characters in a MySQL or pgsql db. Right now I've created a very large array. What I'd like to do is have a form that will allow me to add new characters whenever needed. So far my attempts at this have failed. It always seems that the extended characters get turned into their html entity equivalents before they are inserted into the db. I'm using euc-jp as the character set. I'm pretty much lost with this. Anyone have experience with this that they'd like to share? (on or off list is fine.) Thanks, Chris. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] storing japanese in mysql (or pgsql)
Hi, Chris W. Parker [EMAIL PROTECTED] wrote: (I posted this to another list yesterday without response, so if it looks familiar, that's why.) Hi. I'm working on a small study aid for myself (and anyone else that wants to use it) and I could really use the ability to store Japanese characters in a MySQL or pgsql db. Right now I've created a very large array. What I'd like to do is have a form that will allow me to add new characters whenever needed. So far my attempts at this have failed. It always seems that the extended characters get turned into their html entity equivalents before they are inserted into the db. What exactly do you mean by extended characters? And, do you mean all *other* characters are inserted properly? Anyway,... I'm using euc-jp as the character set. I'm pretty much lost with this. Anyone have experience with this that they'd like to share? (on or off list is fine.) Well, setting the default-character-set to ujis for both the server and the client works for me. First check your characterset(s): mysql status If they're not ujis (for euc-jp), add this to your my.cnf file: (Under [mysqld] and [client]) default-character-set = ujis Restart your servers. Btw, check your php.ini as well and make sure that your settings under [mbstring] are correct. HTH, - E - __ Do You Yahoo!? Yahoo! BB is Broadband by Yahoo! http://bb.yahoo.co.jp/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php