SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Chart List Import problem (General)

posted by Dieter Simader(R), 16.03.2015, 11:09

» Hi,
»
» First of all, for producing such a good program, please accept my sincere
» thanks!
»
» A few days ago I downloaded and it and work about on...
»
»
» My mother language is Turkish and I live in Turkey. In our country GL chart
» has over 300 items. I prepared 2 files for it, one in iso-8859-9 and other
» one utf8 form.
»
» This is the any one line from this SQL for your info:
» "
» insert into chart (accno,description,charttype,category,gifi_accno,link)
» values ('103','Verilen Çekler Ve Ödeme
» Emirleri(-)','A','A','AR_paid:AP_paid','');
» "
»
» When I want to import complete GL chart SQL file from my computer, can see
» all on monitor, but after the latest click on button, get the following
» error:
»
» "
» DBD::Pg::db do failed: ERROR: value too long for type character(1) at
» SL/AM.pm line 122.
» Content-Type: text/html
» Error!
»
» INSERT INTO chart
» (accno, description, charttype, gifi_accno, category, link,
» contra)
» VALUES ('','description',
» 'charttype', 'gifi_accno',
» 'category', '', '0')
» ERROR: value too long for type character(1)
» "
» Would you please check it where goes it to wrong?
»
» Sincerely,
»
» Tayfun

character set for dataset and the character set for the imported data must match.

 

Complete thread:

Back to the forum
Board view  Mix view
986 Postings in 325 Threads, 327 registered users, 117 users online (0 registered, 117 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum