Null values when using the SQL convert function  Zero-length strings

Chapter 3: Using Java Classes in SQL

Java-SQL string data

In Java-SQL columns, fields of type String are stored as Unicode.

When a Java-SQL String field is assigned to a SQL data item whose type is char, varchar, nchar, nvarchar, or text, the Unicode data is converted to the character set of the SQL system. Conversion errors are specified by the set char_convert options.

When a SQL data item whose type is char, varchar, nchar, or text is assigned to a Java-SQL String field that is stored as Unicode, the character data is converted to Unicode. Undefined codepoints in such data cause conversion errors.





Copyright © 2005. Sybase Inc. All rights reserved. Zero-length strings

View this book as PDF