Gena
Posts: 591
|
| Posted: 06/03/2008, 3:20 AM |
|
I'm confusing a bit. How i need to setup CCS and my mySQL db to support accent character (like à°èéòç (<-- not sure if Forum support it as well!  ) a' e' etc). I set DB to utf8 support and I think db is OK. If I write directly to db then I can see that characters on the web page correctly. But If I have some Record and put that characters into TextBox fields and submit it - then I got ???? marks in my DB. Something wrong happaned when I submit... Anybody have clear idea where and how i need to set (check) it please?
_________________
Gena |
 |
 |
wkempees
Posts: 1679
|
| Posted: 06/03/2008, 3:59 AM |
|
What did you enter at:
- Project Settings->Server/Script->Encode Extension
- Project Settings->Server/Script->Locales & Encodings
- Are you useing Internationalization?
Does your message screen give blue warnings about encoding when you press Publish?
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Gena
Posts: 591
|
| Posted: 06/03/2008, 5:03 AM |
|
Quote wkempees:
What did you enter at:
- Project Settings->Server/Script->Encode Extension
- Project Settings->Server/Script->Locales & Encodings
- Are you useing Internationalization?
Does your message screen give blue warnings about encoding when you press Publish?
hi, Walter
yes,
- iconv
- File Encoding - Unicode (UTF-8)
- yes, I'm using Internationalization
I got one messages: Warning:The 'Iconv' encoding extension requires PHP 5.0.0 or above to work properly.
this is strange, I'm using PHP Version 4.4.4 and there is iconv module installed:
iconv
iconv support enabled
iconv implementation libiconv
iconv library version 1.9
Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1
_________________
Gena |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/03/2008, 5:44 AM |
|
I have all set to Unicode(UTF-8), including Internationalization (press edit/change on the language)
and Iconv not set, property is blank.
Seems to work fine.
My problem was in setting MySQL up right with UTF8 and sorting.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Gena
Posts: 591
|
| Posted: 06/03/2008, 8:18 AM |
|
Doesn't work. My setting are like this:
ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 18432 kB'
and for this field: Collation - utf8_general_ci
btw I have other project withthe same setting and it works on the same environment...
_________________
Gena |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/03/2008, 8:23 AM |
|
You do have support to help you out. http://support.yessoftware.com.
Settings for DB look allright to me.
Have you tried, setting Locales/Encoding and ServerScript to UTF8
removing iconv and watching the messages in the message box.
You might need to overwrite the META encoding line in the HTML
But I am just pointing here.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Gena
Posts: 591
|
| Posted: 06/03/2008, 8:29 AM |
|
no, I'm not contacting support yet. because I don't know the reason it works like this: one project works and other- doesn't. I have compared all settings and it seems the same... but doesn't work. strange.
_________________
Gena |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/03/2008, 8:44 AM |
|
What works and what doesn't?
Is it on the deployment platform or at design as well?
Same versions, same databases?
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
datadoit
|
| Posted: 06/03/2008, 10:19 AM |
|
Gena wrote:
> no, I'm not contacting support yet. because I don't know the reason it works
> like this: one project works and other- doesn't. I have compared all settings
> and it seems the same... but doesn't work. strange.
> ---------------------------------------
When doing your comparisons, might want to look directly into the Common
file(s) for differences. I've run into an issue similar to your's in
the past with encode settings, and it turned out that Project Settings
weren't actually getting written to the appropriate functions in
Common.php due to custom coding within.
|
|
|
|
Gena
Posts: 591
|
| Posted: 06/03/2008, 10:48 AM |
|
Thanks,
just compared common.php and it seems the same settings here.
_________________
Gena |
|
|
|
