Postgresql Database Localization

ANTS is a client/server VB application that was developed in the United States. In the past three months this application has been released for use in other countries:

Europe: Germany, Sweden, Spain, France


Asia Pacific: South Korea

Due to date, time, numerical (decimal), currency, language/format differences from country to country communication between the client application (MS Access) and database (PostgreSQL) seems to cause errors. For example, in the American system a decimal number is represented as: 1,234.56 however in the European system its represented as 1.234,56 . As a result when this value is inserted into the database it comes back with an error stating that the format is incorrect. Currently, the database encoding is SQL_ASCII. The current method that’s used today to get around this issue is to trigger a VB module that changes the users system settings to United States when they are using this application. However, this causes problems when they want to use other software while ANTS is open.

The recommended solution would be to have the database accept/understand the incoming data and store the data in an american format.

Links for reference:

[url removed, login to view]

[url removed, login to view]

Habilidades: Visual Basic

Veja mais: postgresql localization data, database localization, is incorrect, asia pacific language solution, access database module, client database software, american software, united states as, South Australia , recommended, postgresql c++, pacific, numerical solution, localization, Korea, database australia, asia pacific, accept language, client server encoding, application store visual basic, differences, settings visual basic language, currency html, database example, visual basic currency

Acerca do Empregador:
( 7 comentários ) Rochester Hills, United States

ID do Projeto: #143904

1 freelancer está oferecendo em média $300 para esse trabalho


Hi, I am 7 years experience progarammer from Singapore. I have good knowledge in Localization based Control Panel settings with VB. I am bidding with confident. Please let me know if you wish me to do ur project. Tha Mais

$300 USD in 7 dias
(0 Comentários)