Diamond characters and I tried defining DB_CHARSET
Hi. I am working on getting my site to 1.5.1 from 1.3.9h. Today I was able to get about 90% of it working and am now trying to solve some of my problems.
One is that I see diamonds with question marks all over. I see that this has been addressed many times and I've read every post I could find. But I must not be understanding something.
First, I put the define statement into /includes/configure.php and the admin/includes define('DB_CHARSET','latin1);
I cleared my cached and reloaded the page and they (darn diamonds) are still there.
I checked my old english.php files to see what they referred to, and the only thing I see is:
setlocale(LC_TIME, 'en_US.utf8').
What else should I look at?
Thank you for your help.
Linda
Re: Diamond characters and I tried defining DB_CHARSET
Re: Diamond characters and I tried defining DB_CHARSET
Thank you so much, that seemed to work.
One thing though, when I ran the script, I got an error message twice (same message):
Processing table [zen_combination_discounts_purchase]:
Dropped index idx_date_added. Unique: No
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
Dropped index idx. Unique: No
Altered field selector_type on zen_combination_discounts_purchase from type char(20)
Table altered: zen_combination_discounts_purchase
Altered field active on zen_combination_discounts_purchase from type char(1)
Table altered: zen_combination_discounts_purchase
Altered field discount_units on zen_combination_discounts_purchase from type char(1)
Table altered: zen_combination_discounts_purchase
Created index idx_date_added on zen_combination_discounts_purchase (date_added). Unique: No
MySQL Error: Duplicate key name 'idx'
Created index idx on zen_combination_discounts_purchase (id). Unique: No
Processing table [zen_combination_discounts_required]:
MySQL Error: Incorrect table definition; there can be only one auto column and it must be defined as a key
Dropped index idx. Unique: No
Dropped index idx_discout_id. Unique: No
Altered field selector_type on zen_combination_discounts_required from type char(20)
Table altered: zen_combination_discounts_required
MySQL Error: Duplicate key name 'idx'
Created index idx on zen_combination_discounts_required (id). Unique: No
Created index idx_discout_id on zen_combination_discounts_required (discount_id). Unique: No
Should I be concerned with this? I'm not sure what idx is.
Linda