(I don't know English well)
Use Debian 5 "Lenny" -32, Gambas 2.7 from repository.
I develop an account program for russians users. It must work with cyrillic
correct.
I have made MySQL5 (default UTF8) database with direct CHARACTER SET UTF8
option, tables with direct CHARACTER SET UTF8 option. Then connected to it
from gambas, output data to GridView. All string fields were not readable.
I run example "Database". It works correct with some french symbols, but
with cyrillic not. Program "Database manager" do the same.
I get sources of Gambas-2.8.2. Opened main.c file of MySQL driver, find
function
<<< static int open_database(DB_DESC *desc, DB_DATABASE *db) >>>.
Add string
<<< fprintf(stderr, "Character set GB[%s] mysql[%s]\n",
GB.System.Charset(), mysql_character_set_name(conn)); >>>
before and after string
<<< set_character_set(db); >>>.
Compiled only this driver, copied it to /usr/lib/gambas2. Run my program.
Result:
<<< Character set GB[UTF-8] mysql[latin1]
Character set GB[UTF-8] mysql[latin1] >>>
in console.
Why latin1 instead UTF-8?
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
