Hello everyone.
Im a greek dude developing a site in one version for both greeks and english people.
Im using ASP MS Interdev and MS SQL server 97.
The problem i have is that when i do:
select * from bands where band name like '%A%'
i only get the english and all the greek characters goes unefected.
When i type it in the sql query analyser i can write in Greek so the query works. But on my Interdev script that im using i can only write in english so there is no posibility to make something like
select * from bands where band name like '%ø%'
directly from the ASP environment so im wondering is it anyway to configure SQL server to do this automatically ?
in other words is it any way o make SQL server or whetever it takes to understand that i need both "A" and "á".
Im a greek dude developing a site in one version for both greeks and english people.
Im using ASP MS Interdev and MS SQL server 97.
The problem i have is that when i do:
select * from bands where band name like '%A%'
i only get the english and all the greek characters goes unefected.
When i type it in the sql query analyser i can write in Greek so the query works. But on my Interdev script that im using i can only write in english so there is no posibility to make something like
select * from bands where band name like '%ø%'
directly from the ASP environment so im wondering is it anyway to configure SQL server to do this automatically ?
in other words is it any way o make SQL server or whetever it takes to understand that i need both "A" and "á".