Re: how to handle data containing '\0'

On Wed, 17 May 2006, EBIHARA, Yuichiro wrote:

> I need to handle String data containing '\0' in my Java + JDBC program.
>
> Now I have to support two versions of drivers, 7.4 and 8.1, but the
> behavior of driver depends on versions when I insert this String value.
>

This was changed between 7.4 and 8.0 when prepared statements changed from
dynamically creating a sql string from the parameters to passing the
parameters separately. When creating a sql string the parameters had to
be carefully checked for ' and \ so checking for \0 was also done. When
passing the parameters separately there is no need for the ' and \ checks
so the \0 check was removed as well either unintentionally or for
perfomance reasons.

New server releases for all versions will be out this week that fix the
problem on the server side by explicitly rejecting \0 rather than
truncating.

Kris Jurka