You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "paramjit.saini" <pa...@viithiisys.com> on 2015/03/20 12:24:02 UTC

Create/update addresses with special characters like :- ä

Hi All,

I have an issue to create/update addresses with *special characters from
front-end*. When i try to create / update address from front-end, it save
text into database with wrong character. I am trying to import
"Skogsgläntevägen" into database but  it will save like "Skogsgläntevägen"
into database.  

When i try to  create/update addresses with *special characters from
back-end* then it is working properly means special character import into
database properly.

Both request using same service to update address.

Please help me to solve this issue.

Thanks,
Paramjit




--
View this message in context: http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Create/update addresses with special characters like :- ä

Posted by Jacques Le Roux <ja...@les7arts.com>.
Interesting, I think we should change that OOTB, I guess it was needed long ago
Or is someone aware of possible drawbacks?

Jacques

Le 20/03/2015 18:09, Mike a écrit :
> If you are using mysql, you have to convert your database to UTF8.  You
> would also have to change the connection settings in entity engine to also
> use UTF8.  Last time I checked, the default settings were latin1.
>
> On Fri, Mar 20, 2015 at 4:24 AM, paramjit.saini <
> paramjit.saini@viithiisys.com> wrote:
>
>> Hi All,
>>
>> I have an issue to create/update addresses with *special characters from
>> front-end*. When i try to create / update address from front-end, it save
>> text into database with wrong character. I am trying to import
>> "Skogsgläntevägen" into database but  it will save like
>> "Skogsgläntevägen"
>> into database.
>>
>> When i try to  create/update addresses with *special characters from
>> back-end* then it is working properly means special character import into
>> database properly.
>>
>> Both request using same service to update address.
>>
>> Please help me to solve this issue.
>>
>> Thanks,
>> Paramjit
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>

Re: Create/update addresses with special characters like :- ä

Posted by "paramjit.saini" <pa...@viithiisys.com>.
Hi All,

I have created a new JIRA issue as per given below link.

https://issues.apache.org/jira/browse/OFBIZ-6203



--
View this message in context: http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357p4665638.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Create/update addresses with special characters like :- ä

Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Paramjit,

I had a similar bug in the past and I think yours might be caused by the
same underlying issue

Either way please open a new JIRA issue and put the exact steps to repeat
so we can try to help you.

Taher Alkhateeb
On Mar 23, 2015 7:58 AM, "paramjit.saini" <pa...@viithiisys.com>
wrote:

> Hi All,
>
> I am using postgresql. Issue not with database, because back-end partymgr
> properly save the correct value in database with special character. I have
> logged all paramteres in PartyContactMechServices.xml under
> updatePartyPostalAddress service, this service is used from both end, but
> when i try to update address from back-end,  parameters show correct text
> as
> i want to save in database but when i try to update address from front-end
> then parameters show wrong text. It means at the time of reach text into
> service, it has been already updated.
>
> Thanks,
> Paramjit
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357p4665635.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Re: Create/update addresses with special characters like :- ä

Posted by "paramjit.saini" <pa...@viithiisys.com>.
Hi All,

I am using postgresql. Issue not with database, because back-end partymgr
properly save the correct value in database with special character. I have
logged all paramteres in PartyContactMechServices.xml under
updatePartyPostalAddress service, this service is used from both end, but
when i try to update address from back-end,  parameters show correct text as
i want to save in database but when i try to update address from front-end
then parameters show wrong text. It means at the time of reach text into
service, it has been already updated.

Thanks,
Paramjit



--
View this message in context: http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357p4665635.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Create/update addresses with special characters like :- ä

Posted by Mike <mz...@gmail.com>.
If you are using mysql, you have to convert your database to UTF8.  You
would also have to change the connection settings in entity engine to also
use UTF8.  Last time I checked, the default settings were latin1.

On Fri, Mar 20, 2015 at 4:24 AM, paramjit.saini <
paramjit.saini@viithiisys.com> wrote:

> Hi All,
>
> I have an issue to create/update addresses with *special characters from
> front-end*. When i try to create / update address from front-end, it save
> text into database with wrong character. I am trying to import
> "Skogsgläntevägen" into database but  it will save like
> "Skogsgläntevägen"
> into database.
>
> When i try to  create/update addresses with *special characters from
> back-end* then it is working properly means special character import into
> database properly.
>
> Both request using same service to update address.
>
> Please help me to solve this issue.
>
> Thanks,
> Paramjit
>
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Re: Create/update addresses with special characters like :- ä

Posted by Pierre Smits <pi...@gmail.com>.
Hi Paramjit,

This seems to be an issue related to the special/purpose e-commerce
component and of the bug kind. Please register a JIRA issue.

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Fri, Mar 20, 2015 at 12:24 PM, paramjit.saini <
paramjit.saini@viithiisys.com> wrote:

> Hi All,
>
> I have an issue to create/update addresses with *special characters from
> front-end*. When i try to create / update address from front-end, it save
> text into database with wrong character. I am trying to import
> "Skogsgläntevägen" into database but  it will save like
> "Skogsgläntevägen"
> into database.
>
> When i try to  create/update addresses with *special characters from
> back-end* then it is working properly means special character import into
> database properly.
>
> Both request using same service to update address.
>
> Please help me to solve this issue.
>
> Thanks,
> Paramjit
>
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Create-update-addresses-with-special-characters-like-a-tp4665357.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>