RE: swe7 character set - strange mappings?

2002-04-03 Thread Philip Semanchuk
I can think is to index - or search- a text file. > > Makis > > > > -----Original Message- > > From: Philip Semanchuk [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 02, 2002 7:21 PM > > To: [EMAIL PROTECTED] > > Cc: 'Ken Menzel';

swe7 character set - strange mappings?

2002-04-02 Thread Philip Semanchuk
Hi everyone, I am trying to understand what's going on here and I hope you can help me. The swe7 characters set in swe7.conf has some really strange mappings in it. For instance, the to_upper array maps ASCII 0x7E (a tilde) to 0x5E (a "hat" aka Ctrl character). Why doesn't a tilde remain a tilde?

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-27 Thread Philip Semanchuk
Ken, That worked! THanks very much. > -Original Message- > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > Sent: den 26 mars 2002 21:25 > To: Philip Semanchuk > Cc: [EMAIL PROTECTED] > Subject: Re: SELECT w/LIKE on Swedish character ö finds ], why? > > > Hi

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread Philip Semanchuk
quot;create table > simple (name tinyblob NOT NULL);" Jim, Thanks for the suggestion, but I already checked that and got no joy -- ö = 0xf6 = 0110 ] = 0x5d = 01011101 Philip > -Original Message- > From: James Housley [mailto:[EMAIL PROTECTED]] > Sent: den 26 mar

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread Philip Semanchuk
THanks Makis, is this bug documented anywhere? > -Original Message- > From: savaidis [mailto:[EMAIL PROTECTED]] > Sent: den 26 mars 2002 18:04 > To: Philip Semanchuk; [EMAIL PROTECTED] > Subject: RE: SELECT w/LIKE on Swedish character ö finds ], why? > > > I ha

SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread Philip Semanchuk
Hi everyone, I am having a little trouble with searching for Swedish characters. When I SELECT using LIKE I get matches that I do not expect. I have created a simple test case that is entirely reproduced below. To summarize, I insert one row into a single-column table that contains the right squar

RE: getting files into BLOBs and some more

2002-03-26 Thread Philip Semanchuk
> > How do I insert files inte BLOBs? > Tomas, I use this PHP function to insert ASCII files into BLOBs. I think it would also work for binary files but I have not tested it. Please note that there are other (perhaps better) ways to insert into BLOBs but this works for me. Good luck, Philip -