On , Alban Hertroys wrote:
On 30 August 2012 10:12, Condor <condor@xxxxxxxxxx> wrote:
Hello,
can I ask is exist some kind of automatic escape string in
postgresql ?
I use pgsql 9.1.5 and I have very interest problem, I have field
with text
string that I cant find normally.
Here is examples (I replace in example Cyrillic encoding because
most of the
ppl don't have cp1251 encoding)
select * from postcodes where namejr LIKE 'LULIN V%';
id | namejr
21 | LULIN VIII
22 | LULIN VII
23 | LULIN VIII
24 | LULIN VI
25 | LULIN VII
26 | LULIN V
buf if I do:
select * from postcodes where namejr LIKE 'LULIN VII%';
result is:
22 | LULIN VII
25 | LULIN VII
as I can see ids 21 and 23 missing that should be: LULIN VIII
I dump follow records to text file and make hex compare,
both ids 21 and 23 is the same (equal).
Any one can give me a little help?
Perhaps the records with ids 21 and 23 have a lower-case 'l' ('L')
instead of an upper-case 'I' ('i'), or something similar? Are the
hex-codes for ids 21, 22, 23 and 25 the same for the substring
reading
'VII'?
Ah, you are absolute right, after an exhausting search I forgot to
compare hex value of other strings.
in LULIN VIII last three hex strings is 0xb2 0xb2 0xb2
and in LULIN VII last two hex strings is 0x49 0x49.
Thank you for the idea.
Hristo C.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
