Create/update addresses with special characters like :- ä

[paramjit.saini]

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.

I have tried to apply changes into my ofbiz as per given below message,but issue is still remaining.

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

I am using ofbiz10.04.

Please help me to solve this issue.

Thanks,
Paramjit

[Mike Z]

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 <
[hidden email]> 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.
>

[Jacques Le Roux]

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 <
> [hidden email]> 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.
>>

[Pierre Smits]

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 <
[hidden email]> 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.
>

[paramjit.saini]

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 parameters 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

[taher]

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" <[hidden email]>
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.
>

[paramjit.saini]

Hi All,

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

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