Export of Spanish characters

Business Central/NAV Technical Forum
1

Hello,

We are currently testing new servers under SQL 2005 and some characters are different for Spain when we export file :
Ú (old system) = ¿ (new system)

Ü (old system) = Á (new system)

The old system is under sql2000

Do you know where to fix this issue ?

Thanks,

Regards

2

Is this using direct exports from SQL ?

How does it look in Dynamics NAV?

3

Hello,

Thanks for the quick reply.

It looks fine in Navision but not in the file exported (opened with Excel or notepad).

It is a customized report to export spanish vendors for legal purpose.

have a good day.

4

Chars will be exported has default language for non Unicode (DOS codepage) defined in Windows control panel. That code page in general isn’t recognized by Excel and other applications. You must convert code page of file other code page. Window applications that can read correctly this kind of codepages are WordPad (not notepad) and Microsoft Access. If can also convert code page using this tool available in download section: http://dynamicsuser.net/files/folders/nav_tools/entry84404.aspx

5

Hello,

Thanks for the reply, actually it does not appear good in wordpad or Access as well.

  • For your information here is below some information that could help to identify the issue. What do you think?
6

Hello,

Thanks for the reply, actually it does not appear good in wordpad or Access as well.

  • For your information here is below some information that could help to identify the issue. What do you think?

New TEST Servers:

SQL server fedk0289: SQl server General Server properties: Latin1_General_CI_AS

Windows OS Code page for fedk0289: Language for non unicode programs is English (UK). Code page for conversion tables are all ticked (code page 850 is present).

Navision Collation: Windows Collation - Danish Norwegian’ case-sensitive, accent-sensitive. ‘Validate Code Page’ is uncheck.

Current PROD servers:

SQL server fedk0060: SQl server General Server properties: SQL_Scandinavian:CP850_CS_AS

Windows OS Code page for fedk0060: ???

Navision collation: SQL collation - Scandinavian sort order, code page 850, case sensitive.Validate Code Page’ is uncheck.

Regards.

7

These settings are from servers and about client settings? File is exported with client settings.