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
