Re: identifying multi-byte characters / coverting
hi that may be but it's got weird beahviour. for example, when u get that in an edit box (like the one u compose mail in) it looks like: (the upper comma). but when i read ur mail, it appeared as it's html character code. in fact, while reading this u may see it as the character code and not the character itself and vice-versa when composing a reply. my question is: does mysql treat/store it as the character code (which would make sense) only? and does it have the upper comma look only when viewed in a browser edit box? also appears like that when u don't apply htmlentities to the output. ty abs --- [EMAIL PROTECTED] wrote: Hi abs, My first post seem to be vanished, so excuse me if this is double. I am not sure if I understand youir problem correctly. Isn' what you describe as the html code for the upper komma or how you want to call it ? ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
identifying multi-byte characters / coverting
hi when ppl paste from MS Word to a text field in a form, characters like apostrophe before s (e.g. It's) in docs looks like (it looks like a comma but at the top). in a mysqldump, i can see that it's stored as #8217;. i tried editing the in a text box and when i reprint it, it's looks like it did. are there any situations where this may cause a problem? and is there any way to filter it or convert it to a single-byte char? i'm assuiming it's multibyte, coz i didn't see it in the ascii char list. thanks abs ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multi-byte characters
Hello, I have a bunch of text with Japanese in it that uses shift_jis encoding. My initial tests show that this encoding has the same problems in MySQL as it does in Perl: it gives false matches. I have to convert the data to the EUC enconding (I think I've seen it called ejis in a MySQL context), and was wondering if anyone can point me to information on how to do that with MySQL and PHP. Paul Flint Japanese to English Translation Kawasaki Japan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multi-byte characters
Hello, I have a bunch of text with Japanese in it that uses shift_jis encoding. My initial tests show that this encoding has the same problems in MySQL as it does in Perl: it gives false matches. I have to convert the data to the EUC enconding (I think I've seen it called ejis in a MySQL context), and was wondering if anyone can point me to information on how to do that with MySQL and PHP. Have you tried setting the language to Japanese and the encoding to shift-JIS yet? -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php