Error converting characters into server's character set. Some character(s) could not be converted.

Error converting characters into server's character set. Some character(s) 
could not be converted.

No changes made to database.

UPDATE Ticket_detail SET problem = 'mecho Team,

I have set up several table repdefs in our test environment (PROD_jam) to 
determine the benefit of having table repdefs in addition to a database 
repdef. After I set up one of the table repdefs I ran several updates on the 
primary table to verify whether the where-clause was smaller on the 
replicate database. When I reviewed the transaction in the outbound queue on 
the secondary rep server (TEST_pqr) it was still including all of the 
columns in the where-clause.


Could you review my set up below and let me know why I am still seeing all 
of the columns in the where-clause? I'm not sure if this is a result of 
specifying the 'send standby' option in the repdef but is my understanding 
that the 'send standby' option was required when mixing database and table 
level replication. Currently the table repdef includes all columns in the 
table so it shouldn't matter whether 'send standby all columns' or 'send 
standby replication definition columns' is used. Should this be expected 
even with 'replicate minimal columns' specified in the table repdef? Any 
help is greatly appreciated! ' WHERE TicketNo = 17



-----------------

Any Idea what to do ?






0
Paula
2/13/2009 12:27:19 PM
sybase.powerbuilder.datawindow 28057 articles. 5 followers. Follow

3 Replies
3808 Views

Similar Articles

[PageSpeed] 55
Get it on Google Play
Get it on Apple App Store

Any solution that it will support all the ASCCI value
what i have to do in PowerBuilder ?
"Paula" <ft252@hotmail.com> wrote in message news:49956727$1@forums-1-dub...
> Error converting characters into server's character set. Some character(s) 
> could not be converted.
>
> No changes made to database.
>
> UPDATE Ticket_detail SET problem = 'mecho Team,
>
> I have set up several table repdefs in our test environment (PROD_jam) to 
> determine the benefit of having table repdefs in addition to a database 
> repdef. After I set up one of the table repdefs I ran several updates on 
> the primary table to verify whether the where-clause was smaller on the 
> replicate database. When I reviewed the transaction in the outbound queue 
> on the secondary rep server (TEST_pqr) it was still including all of the 
> columns in the where-clause.
>
>
> Could you review my set up below and let me know why I am still seeing all 
> of the columns in the where-clause? I'm not sure if this is a result of 
> specifying the 'send standby' option in the repdef but is my understanding 
> that the 'send standby' option was required when mixing database and table 
> level replication. Currently the table repdef includes all columns in the 
> table so it shouldn't matter whether 'send standby all columns' or 'send 
> standby replication definition columns' is used. Should this be expected 
> even with 'replicate minimal columns' specified in the table repdef? Any 
> help is greatly appreciated! ' WHERE TicketNo = 17
>
>
>
> -----------------
>
> Any Idea what to do ?
>
>
>
>
>
> 


0
Paula
2/13/2009 12:41:22 PM
This sounds more like a database question than a programming tool 
question. You might want to ask this in a newsgroup dedicated to the 
RDBMS that you use.



Paula wrote:
> Any solution that it will support all the ASCCI value
> what i have to do in PowerBuilder ?
> "Paula" <ft252@hotmail.com> wrote in message news:49956727$1@forums-1-dub...
>> Error converting characters into server's character set. Some character(s) 
>> could not be converted.
>>
>> No changes made to database.
>>
>> UPDATE Ticket_detail SET problem = 'mecho Team,
>>
>> I have set up several table repdefs in our test environment (PROD_jam) to 
>> determine the benefit of having table repdefs in addition to a database 
>> repdef. After I set up one of the table repdefs I ran several updates on 
>> the primary table to verify whether the where-clause was smaller on the 
>> replicate database. When I reviewed the transaction in the outbound queue 
>> on the secondary rep server (TEST_pqr) it was still including all of the 
>> columns in the where-clause.
>>
>>
>> Could you review my set up below and let me know why I am still seeing all 
>> of the columns in the where-clause? I'm not sure if this is a result of 
>> specifying the 'send standby' option in the repdef but is my understanding 
>> that the 'send standby' option was required when mixing database and table 
>> level replication. Currently the table repdef includes all columns in the 
>> table so it shouldn't matter whether 'send standby all columns' or 'send 
>> standby replication definition columns' is used. Should this be expected 
>> even with 'replicate minimal columns' specified in the table repdef? Any 
>> help is greatly appreciated! ' WHERE TicketNo = 17
>>
>>
>>
>> -----------------
>>
>> Any Idea what to do ?
>>
>>
>>
>>
>>
>>
> 
> 
0
Jason
2/13/2009 2:32:29 PM
Hi Paula;

    Yes, I have had this problem before as well. Especially with PB 10 and 
higher being UTF-16LE Unicode based and the database and/or DBMS set-up as 
ANSI. In that case, sending special characters from the Unicode based PB 
application to the ANSI database could get this error situation. In the 
cases where I was caught on this I had to either change the DB to Unicode 
(ie Upgrade), change the DB connection parameters, use the String (xxxxx, 
ANSI! ) conversion method or even convert the special character to an escape 
sequence and back again on the Select to get around this limitation.

    Can you tell us ...

1) DBMS & version
2) PB version
3) OS (for PB and DB)
etc

-- 
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com


"Paula" <ft252@hotmail.com> wrote in message news:49956727$1@forums-1-dub...
> Error converting characters into server's character set. Some character(s) 
> could not be converted.
>
> No changes made to database.
>
> UPDATE Ticket_detail SET problem = 'mecho Team,
>
> I have set up several table repdefs in our test environment (PROD_jam) to 
> determine the benefit of having table repdefs in addition to a database 
> repdef. After I set up one of the table repdefs I ran several updates on 
> the primary table to verify whether the where-clause was smaller on the 
> replicate database. When I reviewed the transaction in the outbound queue 
> on the secondary rep server (TEST_pqr) it was still including all of the 
> columns in the where-clause.
>
>
> Could you review my set up below and let me know why I am still seeing all 
> of the columns in the where-clause? I'm not sure if this is a result of 
> specifying the 'send standby' option in the repdef but is my understanding 
> that the 'send standby' option was required when mixing database and table 
> level replication. Currently the table repdef includes all columns in the 
> table so it shouldn't matter whether 'send standby all columns' or 'send 
> standby replication definition columns' is used. Should this be expected 
> even with 'replicate minimal columns' specified in the table repdef? Any 
> help is greatly appreciated! ' WHERE TicketNo = 17
>
>
>
> -----------------
>
> Any Idea what to do ?
>
>
>
>
>
> 


0
Chris
2/13/2009 2:57:43 PM
Reply:

Similar Artilces:

Error converting characters into server's character set.
Hello, I am running Sybase ASE as repository (Forms) for application development. I try load some forms (10 MB) into application (its repository in Sybase) but I ve got this message: Error converting characters into server's character set. Some character(s) could not be converted. (Sybase SQL Server error number : 2402 severity : 16 state : 11) I know theese commands : sp_configure "enable unicode conversions" and set char_convert But I dont know which one I need to use it or how exactly I have to use it for conversion of imported data... David ...

'Some character(s) could not be converted into client's character set....'
All-- Received this error from a PB 7.0.3 app running against Sybase 12. One of the suggested workarounds is to run sp_configure against Sybase to enable Unicode. (We are not at all in favor of doing that.) The other alternative is to translate our ANSI-codepage app into Powerbuilder for Unicode. What *is* PowerBuilder for Unicode, and how do we get our hands on it? Is it an add-on, or is it bundled with the ANSI version? TIA, Matt Seltzer IT Tech Analyst, EMI Recorded Music, NA Matt.Seltzer@emicap.com ...

BCP Error: Some character(s) could not be converted into client's character set.
I get the following error on BCP out of a table. Server Message: alpbsfra12 - Msg 2403, Level 10, State 0: WARNING! Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?'). The table contains 1835315 rows and the BCP has been split into a number of 'chunks'. So that the files produced contain 250000 rows a time. On the final bcp we use start and end rows of 1750000 - 2000000 (i.e. -F 1750000 -L 2000000) NB the commands are auto generated. This is the only bcp that produces this error...

WARNING! Some character(s) could not be converted into client's character set.
I received this message when it was executing the command SELECT. Which is the reason? Paulo wrote: > I received this message when it was executing the command > SELECT. Which is the reason? Ignore it ... that simlpy means some characters that are in the result set cannot be displayed on your terminal ( e.g. Unicode characters that are beyond your terminal's capability ). ...

Error converting client characters into server's char. set
Have a Powerbuilder 5.0.04/32bit application that reads data from an Oracle RDB database into the application, and then the application uses this data to update a Sybase 11.5.1 database. Running the EXE on certain workstation everything runs OK, on other workstations we receive the following error message: "Error converting client characters into server's character set. Some characters could not be converted." What could be wrong or missing on those workstations that will not execute the application correctly? Thanks for the assistance. marvin_g_mayer@fleet.com ...

Datawindow ERROR : WARNING! Some character(s) could not be converted into client's characterset. Unconverted bytes were changed to question mark
Hi I am getting this following Error when retrieveing a datawindow which I have created using a stored procedure. SELECT ERROR : WARNING! Some character(s) could not be converted into client's characterset. Unconverted bytes were changed to question marks ('?'). And this is coming only on one client machine.All the clients are on WIndows XP Professional SP1The Sybase Server 12.0 on Solaris 8.0.PLEASE HELPRegardsNaveen Naveen, It sounds like the character set for the db connection on that client is different than for the other machines. Check your open client sett...

Setting the Client's character set to the Server's default
Is there a configuration setting within the server that would set the default character set for the client side? We are on NT4.0 using ASE v12.0. Right now the client seems to default to the locale.dat file settings. At this time we only use one character set (cp850) and I need to be able to eliminate the use of files on the client side and rely on the server setup. I have looked in the product manuals, but do not find much on the client side. TIA "Shawn Simmons" <ssimmons@meddatsys.com> wrote: > Is there a configuration setting within the server that wou...

WARNING: "Application 'sybinit' is using character set 'iso_1', but the Replication Server is using character set 'utf8'
RepServer 12.6 ESD#2 RSSD on ASE 12.5.1 ESD#2 I have the following when I created my first RepServer: 2004/06/22 11:22:04 waiting for server 'SYDNEY_RS' to boot... 2004/06/22 11:22:09 Task succeeded: start the Replication Server. 2004/06/22 11:22:09 Running task: configure the Replication Server. 2004/06/22 11:22:09 SQL Server message: msg 14125, level 11, state 0 2004/06/22 11:24:18 WARNING: "Application 'sybinit' is using character set 'iso_1', but the Replication Server is using character set 'utf8&#...

superreview requested: [Bug 123006] Keyword substitution with %s doesn't escape characters : [Attachment 139974] Encoding all characters for %s replacement (complete urlencoding); no encoding for %S
timeless@myrealbox.com (working) <timeless@bemail.org> has asked neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> for superreview: Bug 123006: Keyword substitution with %s doesn't escape characters https://bugzilla.mozilla.org/show_bug.cgi?id=123006 Attachment 139974: Encoding all characters for %s replacement (complete urlencoding); no encoding for %S https://bugzilla.mozilla.org/attachment.cgi?id=139974&action=edit ...

superreview granted: [Bug 123006] Keyword substitution with %s doesn't escape characters : [Attachment 139974] Encoding all characters for %s replacement (complete urlencoding); no encoding for %S
neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> has granted timeless@myrealbox.com (working) <timeless@bemail.org>'s request for superreview: Bug 123006: Keyword substitution with %s doesn't escape characters https://bugzilla.mozilla.org/show_bug.cgi?id=123006 Attachment 139974: Encoding all characters for %s replacement (complete urlencoding); no encoding for %S https://bugzilla.mozilla.org/attachment.cgi?id=139974&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> >+ shortcutURL =...

Using Apple's MacRoman Character Set and Equivalent Unicode and HTML Characters
I need to use the Apple MacRoman Character Set (see http://orwell.ru/info/macroman) on ASP.NET pages for both user input and display as well as creating an output text file from the same input data all stored in a SQL Server 2000 database. My users are all on Macs (publishing company) using the latest version of IE for the Mac. What do I need to do to ensure that I can receive this input, display it back from the database and create my output text file from the database showing the Apple MacRoman Character Set? Thanks....

superreview requested: [Bug 232722] change 'character coding' to 'character encoding' : [Attachment 140854] Addressed jshin's comments
neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 232722: change 'character coding' to 'character encoding' http://bugzilla.mozilla.org/show_bug.cgi?id=232722 Attachment 140854: Addressed jshin's comments http://bugzilla.mozilla.org/attachment.cgi?id=140854&action=edit ...

superreview granted: [Bug 232722] change 'character coding' to 'character encoding' : [Attachment 140854] Addressed jshin's comments
Scott MacGregor <mscott@mozilla.org> has granted neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com>'s request for superreview: Bug 232722: change 'character coding' to 'character encoding' http://bugzilla.mozilla.org/show_bug.cgi?id=232722 Attachment 140854: Addressed jshin's comments http://bugzilla.mozilla.org/attachment.cgi?id=140854&action=edit ------- Additional Comments from Scott MacGregor <mscott@mozilla.org> sorry, I didn't notice this bug had two patches in it needing review. ...

Changing server's characters set
I have a database, with many tables, lots of data, with default server charset cp850. If I want to convert it for instance to Unicode, is it possible? TIA http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1437.htm "Carlo Borreo" <carlo.borreo@unv.org> wrote in message news:48579fd6$1@forums-1-dub... >I have a database, with many tables, lots of data, with default server >charset cp850. > If I want to convert it for instance to Unicode, is it possible? > TIA > ...

Web resources about - Error converting characters into server's character set. Some character(s) could not be converted. - sybase.powerbuilder.datawindow

Resources last updated: 12/31/2015 3:48:29 PM