Special Charecter in Navision 3.6 on SQL

lakshmivalluru

Navision is not recognising £ symbol. its replacing it with a special charecter something like 'oe'. Any ideas y???? te pagecode and local setings are fine.

facade

lakshmivalluru wrote:

te pagecode and local setings are fine.

Are you sure? :P

lakshmivalluru

s dear i am 100% sure. i didnt menton its on one of our clients database.after they run the ALTER comand in Query Analyser the navison converted £ symbol to a funny looking charecter.

If anybody had similar kind of problem and sorted it then please share.

Afonso

Hello,

If you can tell your government to join Euro coin you'll have the problem solved...

Now, without jokes, have you tried the codeunit 'ASCii <-> Ansii' to export the special caracters? I think is available on the dowload section of mibuso.

Hope this helps,

Afonso