Take a look to charset used in text and the Charset of database... May be in one record you use is an unsupported char... by the Charset of database... this can happen if you paste a value... ( a value not build by your keyboard)
Le Dimanche 15 mars 2015 5h28, "'Chris LeFebvre' lefebv...@comcast.net [firebird-support]" <firebird-support@yahoogroups.com> a écrit : I have at least a dozen different Firebird databases that I’ve created for my own personal use over the years and I develop the front end in Delphi. I recently created a new database for a project and I’d been adding new data into it successfully until today when I tried to insert what would have been the 105th record and my program threw a SQL error -303. I tried a number of different things to try and figure out what is causing the problem but when I wasn’t making any headway I tried opening the database in Database Workbench 3.4.4 and querying the table that is having the problem and then manually trying to add a new record and this is the error I’m getting: ISC ERROR CODE:335544569 ISC ERROR MESSAGEDynamic SQL ErrorSQL error code = -303Arithmetic exception, numeric overflow, or string truncationUnexpected end of file on backup file The layout of the table is fairly simple: CREATE TABLE PLAYLISTS(ARTIST CHAR( 100) COLLATE UTF8,TITLE CHAR( 100) COLLATE UTF8,GENRE CHAR( 30) COLLATE UTF8,PORDER INTEGER,SONGNUM INTEGER,MAINKEY BIGINT,KEYFIELD BIGINT NOT NULL,CONSTRAINT PK_PLAYLISTS PRIMARY KEY (KEYFIELD)) A little trial and error turned up the fact that I can enter data in any column except the Artist and Title, when I enter data into those fields and try and move to another field I get the -303 error. This perplexes me since there are 104 other records in the database that have been added successfully without any problem and there is nothing strange or unusual about the text of the Artist and Title that I’m attempting to insert; I even tried just making either field a single character “a” and I get the same error. I’ve also discovered that I can’t edit any of the other 104 records; for example if I attempt to edit a record with an value of “Carlos Ortega” in the artist field and replace that with “a” and move to another field I get the same -303 error. In case there was some damage to the database I’ve even tried a backup and restore and I still have the same problem on the restored database. I’ve tried using the Database Validation & Repair wizard and it simply says “No errors”. Does anyone have some insight into this problem? Thanks,Chris LeFebvre #yiv2640494804 #yiv2640494804 -- #yiv2640494804ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2640494804 #yiv2640494804ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2640494804 #yiv2640494804ygrp-mkp #yiv2640494804hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2640494804 #yiv2640494804ygrp-mkp #yiv2640494804ads {margin-bottom:10px;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad {padding:0 0;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad p {margin:0;}#yiv2640494804 #yiv2640494804ygrp-mkp .yiv2640494804ad a {color:#0000ff;text-decoration:none;}#yiv2640494804 #yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc {font-family:Arial;}#yiv2640494804 #yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc #yiv2640494804hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2640494804 #yiv2640494804ygrp-sponsor #yiv2640494804ygrp-lc .yiv2640494804ad {margin-bottom:10px;padding:0 0;}#yiv2640494804 #yiv2640494804actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2640494804 #yiv2640494804activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2640494804 #yiv2640494804activity span {font-weight:700;}#yiv2640494804 #yiv2640494804activity span:first-child {text-transform:uppercase;}#yiv2640494804 #yiv2640494804activity span a {color:#5085b6;text-decoration:none;}#yiv2640494804 #yiv2640494804activity span span {color:#ff7900;}#yiv2640494804 #yiv2640494804activity span .yiv2640494804underline {text-decoration:underline;}#yiv2640494804 .yiv2640494804attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2640494804 .yiv2640494804attach div a {text-decoration:none;}#yiv2640494804 .yiv2640494804attach img {border:none;padding-right:5px;}#yiv2640494804 .yiv2640494804attach label {display:block;margin-bottom:5px;}#yiv2640494804 .yiv2640494804attach label a {text-decoration:none;}#yiv2640494804 blockquote {margin:0 0 0 4px;}#yiv2640494804 .yiv2640494804bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2640494804 .yiv2640494804bold a {text-decoration:none;}#yiv2640494804 dd.yiv2640494804last p a {font-family:Verdana;font-weight:700;}#yiv2640494804 dd.yiv2640494804last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2640494804 dd.yiv2640494804last p span.yiv2640494804yshortcuts {margin-right:0;}#yiv2640494804 div.yiv2640494804attach-table div div a {text-decoration:none;}#yiv2640494804 div.yiv2640494804attach-table {width:400px;}#yiv2640494804 div.yiv2640494804file-title a, #yiv2640494804 div.yiv2640494804file-title a:active, #yiv2640494804 div.yiv2640494804file-title a:hover, #yiv2640494804 div.yiv2640494804file-title a:visited {text-decoration:none;}#yiv2640494804 div.yiv2640494804photo-title a, #yiv2640494804 div.yiv2640494804photo-title a:active, #yiv2640494804 div.yiv2640494804photo-title a:hover, #yiv2640494804 div.yiv2640494804photo-title a:visited {text-decoration:none;}#yiv2640494804 div#yiv2640494804ygrp-mlmsg #yiv2640494804ygrp-msg p a span.yiv2640494804yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2640494804 .yiv2640494804green {color:#628c2a;}#yiv2640494804 .yiv2640494804MsoNormal {margin:0 0 0 0;}#yiv2640494804 o {font-size:0;}#yiv2640494804 #yiv2640494804photos div {float:left;width:72px;}#yiv2640494804 #yiv2640494804photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2640494804 #yiv2640494804photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2640494804 #yiv2640494804reco-category {font-size:77%;}#yiv2640494804 #yiv2640494804reco-desc {font-size:77%;}#yiv2640494804 .yiv2640494804replbq {margin:4px;}#yiv2640494804 #yiv2640494804ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2640494804 #yiv2640494804ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2640494804 #yiv2640494804ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2640494804 #yiv2640494804ygrp-mlmsg select, #yiv2640494804 input, #yiv2640494804 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2640494804 #yiv2640494804ygrp-mlmsg pre, #yiv2640494804 code {font:115% monospace;}#yiv2640494804 #yiv2640494804ygrp-mlmsg * {line-height:1.22em;}#yiv2640494804 #yiv2640494804ygrp-mlmsg #yiv2640494804logo {padding-bottom:10px;}#yiv2640494804 #yiv2640494804ygrp-msg p a {font-family:Verdana;}#yiv2640494804 #yiv2640494804ygrp-msg p#yiv2640494804attach-count span {color:#1E66AE;font-weight:700;}#yiv2640494804 #yiv2640494804ygrp-reco #yiv2640494804reco-head {color:#ff7900;font-weight:700;}#yiv2640494804 #yiv2640494804ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2640494804 #yiv2640494804ygrp-sponsor #yiv2640494804ov li a {font-size:130%;text-decoration:none;}#yiv2640494804 #yiv2640494804ygrp-sponsor #yiv2640494804ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2640494804 #yiv2640494804ygrp-sponsor #yiv2640494804ov ul {margin:0;padding:0 0 0 8px;}#yiv2640494804 #yiv2640494804ygrp-text {font-family:Georgia;}#yiv2640494804 #yiv2640494804ygrp-text p {margin:0 0 1em 0;}#yiv2640494804 #yiv2640494804ygrp-text tt {font-size:120%;}#yiv2640494804 #yiv2640494804ygrp-vital ul li:last-child {border-right:none !important;}#yiv2640494804