|
More site info...
Character Sets, Collation, Unicode | Forum profile
|
|
Forum profile page for Character Sets, Collation, Unicode on http://www.mysql.com.
This report page is the aggregated overview from a single forum: Character Sets, Collation, Unicode, located on the Message Board at http://www.mysql.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Character Sets, Collation, Unicode" on the Message Board at http://www.mysql.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Character Sets, Collation, Unicode:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
5
|
15
|
65
|
|
Post:
|
7
|
25
|
93
|
|
|
Character Sets, Collation, Unicode Posting activity graph:
|
Top authors during last week:
user's latest post:
Re: Variable Collation...
Published (2009-12-28 22:22:00)
Hmmm... http://dev.mysql.com/doc/refman/5.1/en/charset-collate-tricky.html Plan A: ALTER TABLE ... MODIFY COLUMN v_DetailPath ... utf8_unicode_ci Plan B: See if this works: ... ExtractValue (v_XML, CONCAT(v_DetailPath,'@StepTypeID' COLLATE utf8_general_ci)) Or is the collation in trouble in v_XML? Or in ExtractValue?
user's latest post:
Re: Problem putting rare Chinese...
Published (2009-12-20 15:53:00)
Please read the FAQ in the MySQL Reference Manual. http://dev.mysql.com/doc/refman/5.1/en/faqs-cjk.html#qandaitem-23-11-1-6
user's latest post:
Re: collation issues.
Published (2009-12-20 10:44:00)
Thanks for the reply Rick, Over the last 2 days, I have identified the problem correctly. Like you said it is not a collation issue. It is totally related to ODBC drivers. I thought it was ODBC 5.1 on the server but apparently the driver on the server is ODBC 3.51, and on my local copy the driver is ODBC 5.1. So when I back it up on the server and restore it on my local database, the characters don't show up right. However, I installed...
|
|
|
|
Latest active threads on Character Sets, Collation, Unicode::
Started 2 days, 13 hours ago (2009-12-28 22:22:00)
by Rick James
Hmmm...
http://dev.mysql.com/doc/refman/5.1/en/charset-col late-tricky.html
Plan A: ALTER TABLE ... MODIFY COLUMN v_DetailPath ... utf8_unicode_ci
Plan B: See if this works:
... ExtractValue (v_XML, CONCAT(v_DetailPath,'@StepTypeID' COLLATE utf8_general_ci))
Or is the collation in trouble in v_XML? Or in ExtractValue?
Started 2 days, 13 hours ago (2009-12-28 22:17:00)
by Rick James
SET NAMES utf8;
Be sure the data in PHP is really utf8.
Dump some characters in HEX to verify what they look like.
Started 1 week, 4 days ago (2009-12-19 18:54:00)
by Niko Huffman
Alternately, is there a way to ensure that the database default collation is applied when a table is created and only the default character set is specified?
In the following script, table1, table3, and table4 are created with the correct character set and collation, but table2 ends up with a default collation of utf8_general_ci, presumably because of the default collation for the utf8 ...
Started 1 week, 3 days ago (2009-12-20 15:53:00)
by Peter Gulutzan
Please read the FAQ in the MySQL Reference Manual.
http://dev.mysql.com/doc/refman/5.1/en/faqs- cjk.ht ml#qandaitem-23-11-1-6
Started 1 week, 5 days ago (2009-12-18 16:00:00)
by Savas Zorlu
Hi All,
I have a mysql database that I use with classic ASP. Database tables are set to utf_general_ci
My website's encoding is windows-1254
Most of the data inserted into the databse is through forms of the website.
My problem is:
special Turkish characters like ğşı are storded in the database as:
ðþý
and in binary they look even weirder (I cannot copy and paste those)...
Started 3 weeks, 5 days ago (2009-12-04 22:31:00)
by Rick James
SET NAMES utf8;
(or whatever encoding your source uses.)
Started 4 weeks ago (2009-12-02 14:24:00)
by Mary Kalinosky
Ted, did you ever find a solution to this problem?
Started 4 weeks, 1 day ago (2009-12-01 18:10:00)
by Paul Svirin
Try running 'SET NAMES utf8' from PHP script right after the connection launch.
---
Paul Svirin
StarWind Software developer ( http://www.starwindsoftware.com )
Started 1 month, 1 week ago (2009-11-23 12:11:00)
by Rick James
Started 1 month, 1 week ago (2009-11-22 15:06:00)
by Rick James
Please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
A PRIMARY KEY is a UNIQUE key, so it disallows duplicates.
|
|
Hot threads for last week on Character Sets, Collation, Unicode::
Started 2 days, 13 hours ago (2009-12-28 22:22:00)
by Rick James
Hmmm...
http://dev.mysql.com/doc/refman/5.1/en/charset-col late-tricky.html
Plan A: ALTER TABLE ... MODIFY COLUMN v_DetailPath ... utf8_unicode_ci
Plan B: See if this works:
... ExtractValue (v_XML, CONCAT(v_DetailPath,'@StepTypeID' COLLATE utf8_general_ci))
Or is the collation in trouble in v_XML? Or in ExtractValue?
Started 2 days, 13 hours ago (2009-12-28 22:17:00)
by Rick James
SET NAMES utf8;
Be sure the data in PHP is really utf8.
Dump some characters in HEX to verify what they look like.
Started 1 week, 4 days ago (2009-12-19 18:54:00)
by Niko Huffman
Alternately, is there a way to ensure that the database default collation is applied when a table is created and only the default character set is specified?
In the following script, table1, table3, and table4 are created with the correct character set and collation, but table2 ends up with a default collation of utf8_general_ci, presumably because of the default collation for the utf8 ...
|
|
Size: 487 bytes
