Now I have a ready-made PB9.0 + SQL SERVER 2000 database software, the database is now replaced with MySQL5.1 database, but now in addition to a problem, when the data table have Chinese data, the data window object to retrieve the data, will prompt an error message: Select error: SQLSTATE=22018 [MySQL] [ODBC Driver 5.1] [mysqld 5.1.37 - community], couldn't retrieve the record, also please advice, I appreciate, thank you!

CodePudding user response:

The client to access the data in the normal?
Mysql character set is?

CodePudding user response:

Ask you also didn't answer!

CSDN sucks, see a message I have to log in several times! Very trouble!
A few months didn't solve!

Mysql and Java with much,
PB with asa!
English, Chinese is wrong, that related to library's character set.

CodePudding user response:

Haven't configure the client, my connection is my own server, mysql character set is UTF8, with Navicat for mysql data visualization tool is you can see if I deleted from the table in Chinese records, PB test program can be run, when inserted into the Chinese data, the text in the mysql gibberish

CodePudding user response:

Because the customer database copyright into consideration, so want to use free database software

CodePudding user response:

reference 4 floor fuwulong response:

because the customer database copyright into consideration, so want to use free database software

And # 1/f, friend, depressed, CSDN reply content is often not the Chinese ~ ~

Repeat the question: the first floor the building Lord your MYSQL default character set is how much?

CodePudding user response:

MYSQL character set is UTF8
This is my MYSQL my ini related configuration
[client]

Port=3306

[mysql]

Default - character - set=utf8

# The default character set that will be, informs The when a new schema or table is
# created and no character set is defined
Default - character - set=utf8
Would you please advise!

CodePudding user response:

Use SQL2005Express, general of small businesses use should be no problem, only support a CPU, a single database largest 4 g, you can build a few more database when the spare tire, the mainest is free.

CodePudding user response:

The landlord to solve this problem, I also met the same problem, for the building

CodePudding user response:

I also met, how to solve?

CodePudding user response:

Mysql my. Ini
With reference to the sixth floor
Looking for a
Default - character - set=
Change
Default - character - set=utf8

CodePudding user response:

Pb prepared

The SQLCA. DBMS="JDBC"
The SQLCA. LogPass=& lt; * * * * & gt;
The SQLCA. LogId="root"
The SQLCA. The AutoCommit=True
The SQLCA. DBParm="Driver='org. GJT. Mm. Mysql. Driver', URL='JDBC: mysql://localhost: 3306/rj', TrimSpaces='Yes', IdentifierQuoteChar=' utf8 '