pcsoft.us.windevCopyright 2026, PC SOFT24 Sep 2015 19:11:00 Z18 Sep 2015 23:56:00 ZHello, does anyone knows how to define a MySQL table in the Windev Analysis that is Unicode, using the utf-8 charset ? Or do I need to do it in (SQL)code ? and if so, how can I use that table in my program if it's not defined in the analysis ? grtz Patrick30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54131/read.awp24 Sep 2015 19:11:00 ZIn the mean time I have contacted PCS support, and we found the cause of my problems. The version of the MySQL server we are us…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54131/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54131/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54087/read.awp22 Sep 2015 17:07:00 ZHello Fabrice, I'm using Native Access to the MySQL database. I followed your advice, and made a simple two field table in…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54087/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54087/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54082/read.awp22 Sep 2015 11:28:00 ZHello again, two questions: - are you using the native access or oledb/odbc? - did you try the contrary: create the tab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54082/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54082/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54074/read.awp21 Sep 2015 23:25:00 ZI've did the test with a normal text-field in stead of a unicode text-field, and then I don't have any error, but the charset of…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54074/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54074/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54073/read.awp21 Sep 2015 23:01:00 ZHello Fabrice, I've created a new table in the analysis, named "test", and it has two fields, the autonumbered field, and a t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54073/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54073/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54072/read.awp21 Sep 2015 22:53:00 Zyep... but it doesn't answer my question... what happens for a table where you define a field as UNICODE string? Best rega…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54072/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54072/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54071/read.awp21 Sep 2015 22:27:00 ZHello Fabrice, the DDL-statements that I was showing are just as an example, the DDL-code for the real tables is a lot bigger…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54071/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54071/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54070/read.awp21 Sep 2015 22:18:00 ZHi Patrick, now I'm confused... Why would you want a unicode charset in a table/file containing only INTs like the one you…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54070/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54070/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54066/read.awp21 Sep 2015 19:09:00 ZI think I've explained my problem wrong. When I define a MySQL table in the Windev Analysis, and I check it in a took like Na…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54066/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54066/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54060/read.awp21 Sep 2015 09:42:00 Ztry change character set in project description -> language ->various tabhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54060/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54060/read.awp[WD20] UTF-8 charset on MySQL in analysisguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54053/read.awp20 Sep 2015 23:13:00 ZHi Pattrick in windows you no need to worry about that "Unicode-enabled functions in Windows use UTF-16, it is also possible…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54053/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54041-wd20-utf-8-charset-mysql-analysis-54053/read.awp[WD20] UTF-8 charset on MySQL in analysis