On 30-3-2012 9:49, nathanelrick wrote:

> Hello,
>
> how to use the x notation (ex ID=x'049094') inside parameter ?
>
> When i do
>
> insert into ... (Field1) Values (?);
> with the parameter x'049094' i receive an error
> probably i can write any char i want (from #0 to #255) inside parameter and i don't need the x notation ?

The x'...' is a literal escape. If you use parametrized queries you need
to set the bytes in the parameter, however depending on your connection
characterset and database character set this might cause transliteration
errors if you use invalid byte combinations for the character set,
unless the field is CHARACTER SET OCTETS.

Mark

--
Mark Rotteveel