How to set Charset to utf8 ?

[gigaz]

Hi all.
I'm using SC6.1.3 and scauto 4.0.2

I'm trying to force Scauto to send email with the charset UTF8 instead of windows-1252

My problem is that international caracters like korean or french (éàè) cannot be displayed :

With debug mode, I can see that:

03/19/2008 17:33:30 pid (2028)(5968) SCAuto Mail Version 4.0.2
03/19/2008 17:33:30 pid (2028)(5968) Initializing...
03/19/2008 17:33:30 pid (2028)(5968) Started as a service: No
Cmdline args: No cmd line arg
scmapi.ini file:
header_content-type:1
header_content-transfer-encoding:1
encode_subject:1
encode_message:1
encode_to:1
debugmemory:1
debugfileevents:1
debug:1
log:scmapi.log
profile:Outlook
server:localhost.12690
event_map_dir:EventMap
usemaps:1
events:1
03/19/2008 17:33:30 pid (2028)(5968) Logon information: MAPI Profile: Outlook, account: EMEA\falcon
03/19/2008 17:33:30 pid (2028)(5968) Open:MAPIInitialize OK....
03/19/2008 17:33:30 pid (2028)(5968) Open:MAPILogonEx OK....
03/19/2008 17:33:30 pid (2028)(5968) Open:OpenAddressBook OK....
03/19/2008 17:33:30 pid (2028)(5968) Service Provider: Microsoft Exchange Server, Display Name: Mailbox - Falcon,MailBox.
03/19/2008 17:33:30 pid (2028)(5968) open_default_store:OpenMsgStore OK....
03/19/2008 17:33:30 pid (2028)(5968) Logged on to MAPI successfully.
03/19/2008 17:33:30 pid (2028)(5968) debug: connected to <localhost.12690>
03/19/2008 17:33:30 pid (2028)(5968) debug: sc_language is <utf8>
03/19/2008 17:33:30 pid (2028)(5968) debug: sc_charSet is <WINDOWS-1252>

sc_language is set in sc.ini (language:utf8)
-But how can I set sc_charSet to <utf8>?
-Any idea of where SCAUTO go to reach information for setting sc_charSet with <WINDOWS-1252>?

Thanks!

[Alfredas]

Try to check the database settings. Maybe there you didn't set the charset correctly. If you using oracle db, then go to regedit and look for NLS_LANG parameter. There should be UTF8 too. Hope this helps you though you've written very long ago. I've just noticed your thread.

[Artur]

Hi,

there are few parameters in sc.ini which plays a role in proper configuration. Unfortunately they are not very extensively described. So when we had to set up our environment to have Polish characters in SC and mails, we really had to go on trial-error
approach. I can not recall correctly what they were: dblang, lang - see in help. Do the "sc -helpall " to see all the parameters
and read about all "lang".

The parameters like NLS_LANG are important as well. All together must be set up correctly. But some parameters are not possible to change without Oracle reinstallation (not the binary files, I mean reinstall the instance).

I don't have a document on hand where I documented all the settings. I will post (if you wish) it in about 1-2 days, if I will forget - remind me. Today I am very busy, sorry.

Is n't 1252 the natural charset of western version of Windows ???? I am a little surpirsed by the way, I thought that french is "west - enough" to not to have these problems ...

regards
Artur

ps. I thought this post was new But I see it was posted few months ago. So maybe it is not a rush ))

[elvo]

HP told us this:


"
As a test, can you add
language:UTF8 to the ini file
And
scenter -listener:12690 -codepage:1250
In the cfg file. Restart the system and retest. But also test emails being received...
Note: The -codepage: will throw an error in the sc.log file that the parm is not valid. This is okay, the parm is invoked and does work. It forces required code from the scauto products to be invoked that will in turn process the utf8 characters correctly."


That being said, I'm not sure scauto handles UTF-8 properly...

[mateuszk]

That being said, I'm not sure scauto handles UTF-8 properly...

It does (surprise, surprise!).

We had similar problems with multilingual setup.
Came up with a simple solution:

1. sc.cfg:
scenter -listener:12690 -language:UTF8

2. scsmtp.ini (ver 1.0.2):
- remove all the encoding bits
- this is all we've got:
server:localhost.12690
smtpserver:smtp.netpost
smtpport:25
log:E:\Server\logs\scsmtp.log
smtpuser:***@***
smtp_bcc:***@***

We send notification in both FR and NL and it works very well.

[elvo]

Indeed, that works. Great!

[Alfredas]

Which databases do you use? I tried to use this -language:utf8 parameter for correct encoding of lithuanian language in the listener initialization command for service manager:

sm -scautolistener:12690 -language:utf8

Unfortunately, instead of lithuanian characters I got ąšęėįėšū9įųū9Ä
If I am not using this -language:utf8 I see that I get the windows-1252 character set where lithuanian characters are interpreted differently. Any ideas?

Thanks

[mateuszk]

What about the encoding for your RDBMS?
Does your SC/SM instance use utf switches or some different language settings?

[Alfredas]

As far as I know MS Sql server 2005 which I'm using does not support utf. Have you ever configured the SM system on SQL server so it encoded the exotic characters correctly?

[mateuszk]

We run SC 6.2 + MSSQL (no P4) with the setup I described in the previous post.
Lots of "exotic" characters as we run FR + NL + EN.

In order to troubleshoot your setup I'd have to take a look at all the ini files (sm & smtp).
I have not tried setting this up on SM yet, but don't see why should it be a problem.