MySQL Forums
Forum List  »  Newbie

SELECT BETWEEN 'a' AND 'd' - problem
Posted by: Romans Vorobjovs
Date: April 12, 2005 07:22PM

Hello, Shantanu Oak once helped me out with this syntax,
and it's working, but now I have another problem.

There are special symbols in my native language (latvian).
You can see these symbols here: http://lab.serveris.lv/abc.jpg

So how should I change the syntax to solve the encoding (windows-1257) problem?
Is it possible?

SELECT * FROM table WHERE LEFT(lower(names), 1) BETWEEN 'a' AND 'd' ORDER BY names


Thanks a lot,
Lab.

Options: ReplyQuote


Subject
Written By
Posted
SELECT BETWEEN 'a' AND 'd' - problem
April 12, 2005 07:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.