What steps will reproduce the problem?
1.I run "d = pyodbc.connect("DSN=****;PWD=****")"
2.next, run "cur = d.execute("select ***, ***, ***, ... from [table name]")
-> [table name] has 28 columns(3 primary key, one of columns is varchar(120)
for multibyte character(Japanese, etc))
3.next, run "cur.fetchone()"
What is the expected output? What do you see instead?
In above 3., I looked following error.
"Then happens error: Error: ('HY000', '[HY000] [Oracle][ODBC][Ora]ORA-01406:
fetched column value was truncated\n (1406)(SQLFetch)')"
What version of the product are you using? On what operating system?
Python 2.7.5 + pyodbc-3.0.7.win32-py2.7.exe
Database: Oracle 9i
Please provide any additional information below.
By the way, I test and confirmed same code in other python program "cx_Oracle".
That program do not has an error.
Perhaps, I think that output way of multibyte(not unicode?) of pyodbc is different from the cx_oracle.
cx_oracle: u'\uff30\uff33\uff30\uff30\uff0c\uff21\uff14\uff0c"
pyodbc : '\xef\xbc\xb0\xef\xbc\xb3\xef\xbc\xb0\xef\xbc\xb0\xef\xbc\x8c\xef\xbc\xa1\xef\xbc\x94'
(In other words, length of output character is different?)
Original issue reported on code.google.com by lumid...@gmail.com on 4 Dec 2013 at 6:36
Original issue reported on code.google.com by
lumid...@gmail.comon 4 Dec 2013 at 6:36