| Subject | Re: [firebird-support] Store any char from #0 to #255 in a varchar field ? |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2011-01-14T12:16:06Z |
Hello Stéphane,
create table MyChars (s varchar(25) character set octets)
If you use Firebird 2.5, you can even use hex digits to insert:
insert into MyChars values (x'65D040FF2055005429D1')
Cheers,
Paul Vinkenoog
> is it possible to store any char from #0 to #255 in a varchar field ?Yes, use character set OCTETS:
create table MyChars (s varchar(25) character set octets)
If you use Firebird 2.5, you can even use hex digits to insert:
insert into MyChars values (x'65D040FF2055005429D1')
Cheers,
Paul Vinkenoog