This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | I18N - make wish tutorial able to use and diaplay non ascii | ||
---|---|---|---|
Product: | usersguide | Reporter: | Ken Frank <kfrank> |
Component: | Code | Assignee: | Jeffrey Rubinoff <jeff_rubinoff> |
Status: | RESOLVED FIXED | ||
Severity: | blocker | Keywords: | I18N |
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Exception Reporter: |
Description
Ken Frank
2008-08-22 23:47:31 UTC
Ken, Can you tell me how you did (a)? I am not exactly a MySQL guru. Jeff, I used phpmyadmin and/or command line to query the different character set values of mysql - it has a lot of them and its sometimes not clear about what each does (see mysql manual chapter 9 on this topic). I took a brute force approach for this experiment and changed all values except the server value - this command can be used to show the values show variables LIKE 'character_set%' then changed the values that were not utf-8 to it BTW, if there is a table created with specific character set noted, then it too needs to be changed; I can't recall if this demo sql scripts did that or not. ken.frank@sun.com BTW #2, my typo below is step c, should be SET NAMES, not NANES. Fixed according to Dean Ellis' advice. Character sets are set at the table/column level instead at the database level, since table/column settings override database settings. Fixed only on staging server version. to be specific, I added ken's steps b and c: wherever a database connection is created, I added mysql_query("SET NAMES");, and I added the meta charset tags to html sections, at least the ones where character data will be displayed. Instead of setting the database to use utf-8, I added the following MySQL to wherever character type data table columns were created. For example, note the "name" and "password" columns below: CREATE TABLE wishers( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL UNIQUE, password CHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) |