Bug #3457 [SAP AG][SQLOD32 DLL]Restricted data type attributes violation

• Submitted: 13 Apr 2004 7:49
• Modified: 15 Apr 2004 6:42
• Reporter: Jun Gao
• Status: Can't repeat
• Category: MaxDB
• Severity: S1 (Critical)
• Version: 7.5.00.03
• OS: Windows (Windows2000)
• CPU Architecture: Any

[13 Apr 2004 7:49] Jun Gao

Description:
The database is setup as unicode db, but when there is Chinese in the record I always get error "[SAP AG][SQLOD32 DLL]Restricted data type attributes violation" when I am accessing the record via ODBC unicode.

How to repeat:
create a unicode database
create a table with two fields (id smallint, txt varchar(50) unicode)
put some non english text in txt field (better Chinese)
try to retrieve data via Access based on ODBC unicode driver.
Error will apear!

[15 Apr 2004 6:28] Jun Gao

Can anyone give some help?

[15 Apr 2004 6:42] Marko Mäkelä

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Could you please send a complete test case (source code of short test program, and the CREATE TABLE statement)?

[15 Apr 2004 6:54] Jun Gao

for example
I create a table like following:
"CREATE TABLE test(ID smallint not null, TXT varchar(50) unicode)"
then I put data record as following via SQL studio
"INSERT test values(1, '<any kind of Chinese words>')"

I try to retieve the data via ODBC using driver "SAPDB(Unicode)"
"Select * from test"

I will encounter the error "[SAP AG][SQLOD32 DLL]Restricted data type attributes violation"

Hopefully this can help to understand the problem

Thanks