[firebird-support] Strange behaviour with char '#'

2017-12-15 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Hi,

I stumbled upon the following problem:
I have a field of type varchar(7). When inserting the string '#ee' the 
field value remains zero.

Does the character '#' have a special role?

Regards,
Martin


Re: [firebird-support] Strange behaviour with char '#'

2017-12-15 Thread Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
On 15.12.2017 at 09:17, Köditz, Martin martin.koed...@it-syn.de 
[firebird-support] wrote:

> I stumbled upon the following problem:
> I have a field of type varchar(7). When inserting the string '#ee' the 
> field value remains zero.
> 
> Does the character '#' have a special role?

No it doesn't. I've made a quick experiment a moment ago, just to make 
sure, and '#ee' was inserted just fine. I'd suspect some client-side 
processing of the string (you didn't provide any info about the client) 
or just a plain bug in the client code.
Try it with isql (I've tried both isql and flamerobin). If it works, 
check your client code.

regards
Tomasz

-- 
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/



Re: [firebird-support] Strange behaviour with char \'#\'

2017-12-15 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Well, I've tried with flamerobin and PHP ibase driver.

Then I have to examine the problem more closely.

Regards,
Martin


Re: [firebird-support] Strange behaviour with char \'#\'

2017-12-15 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
I found the cause. There was a trigger that acted as a validator and removed 
the strings.

Thank you all.
Martin