Re: please help, Error on Saving chinese char to mysql server

[Rick James]

ENGINE=InnoDB -- good
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci -- see below
COMMENT='" & ZTblCmt & "' -- ok
AUTO_INCREMENT=21 -- Don't explicitly state this
CHECKSUM=1 -- ok
DELAY_KEY_WRITE=1 -- not relevant to InnoDB
ROW_FORMAT=DYNAMIC -- not relevant to InnoDB

NVARCHAR --> VARCHAR (there is no NVARCHAR in MySQL)

For Chinese, I recommend you go with 4-byte utf8 encoding. What you have is limited to 3-byte characters, which leaves out a few Chinese characters.

DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

> "Multiple-step operation generated error. check each status value"

That is some cryptic error message from VB or ODBC, not MySQL.

Your db_user or db_pass may have special characters that cause trouble in building the string? Print out the string.