Collate problem - please help
Posted by: Mariusz Gniazdowski
Date: February 05, 2005 12:42AM

Hi.

Detailed description with screenshots:

http://mrg.risp.pl/stuff/collate-problem.php


Other observations:

1. character_set_results are default set to latin2. Then results returned by simple php test script (connect & select) are displayed properly in browser ( <meta ..... encoding="utf8"> included in <head></head> )

2. Setting character_set_results to NULL or utf8 causes inproper displaying, like the browser didnt know to display utf8 data.



3. Running script that inserts UTF8 string (prepared by gedit - 100% proper utf8) causes:
- data is inserted like it was latin1 or latin2 (? probably..),
- it is properly displayed when rest of rows are displayed badly, and vice versa.


So it is strange situation: I set EVERY variable that has "character_set" in its name to utf8, then insert UTF8 string, and i get something that is probably not UTF8...

The main problem is: how to sort utf8 column with utf8_polish_ci collation.

Options: ReplyQuote


Subject
Views
Written By
Posted
Collate problem - please help
3752
February 05, 2005 12:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.