in reply to WIN32::ODBC - text field String data, right truncation
You need to show the actual code you're using to insert and retrieve the data, as well as the DDL to create the table. Otherwise it's pretty much impossible to say.