Quote:
artigas wrote:
Greetings -
While all this is beyond what I already know about PHP and MySQL, all things being the same, has anyone looked at the data in the table itself?
I will make the sugestion that you dump (not sure of how to do this) the data to a text file and have a look to see that it all looks reasonable and that there are no 'unsual' (what would those be?) characters in the data.
Martijn , artigas you're right
Sorry for not testing English chars b4 all those tests, when I posted it in the begining and being told it was brought up b4, I was sure it's happaning in English too.
I deleted all Xdir tables, and made about 200 test records in English, making test over and over again, and all works fine, from some reason Hebrew chars are making problems here, and I say here due to the fact that I never ever had a problem with xoops, nor another MySql app.
My local MySql have a Hebrew chars encoding, but till now I didn't had any problems also with a regular (Non Hebrew MySql) so .. now I'm lost more then ever.
The funny thing now is that I mixed 2 alpha panels (Heb + Eng) to be able to look @ the behaviour, and when I look for "a" I get all a results plus the first 4 Hebrew letters results.
Quote:
Martijn wrote:
Perhaps a workaround would be like the suggested handling in php, to query all records and only return the records where title starts with a '$list'. Let me know if you find another way to solve the root of the problem, which is the database. If there is not, I will have a look on a short workaround in php.
Oh how I need it now ...
I thought about 2 scenarios:
1. use something like "str_replace" or ereg_replace() and store the first heb char in the database.
2. which is going back to stone age ... to dedicate one of the fields for something like "
File the record under the letter" ... STONE AGE !!!!
Did I mentioned I never had those problems with XOOPS and Heb Chars, all, including the search is working perfect !!!
I'm fighting this Xdir from the first minute I touched it .... from the "register_globals" I had to open for it, through the global search I embaded in it till this Alphabet thing.
HELP !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!