Smart Quotes

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Smart Quotes

lizquigg
I have a Filemaker database that I have updated through many versions of Filemaker  and Lasso.  I am working on a development version of Lasso 9.2 on Windows 2012 and Filemaker 13 on a separate Windows server and I have noticed some of my fields with smart quotes are displaying incorrectly in some systems, but not all (e.g., my MacBook Air with Mountain Lion and my colleagues iMac with Mavericks, a Windows system work fine, but my iMac with Mountain Lion fails.   When I access it with Lasso 8.6 on Windows 2008 and Filemaker 13 on my iMac with Mountain Lion, it looks fine.  My colleague with Windows has the problem with the Lasso 9 version, but not Lasso 8.6.

Lasso 9 -  "��pensylvanica,"��
Lasso 8.6  “pensylvanica,”  - smart quotes look fine.

If I export the data from Filemaker and import it into Excel, I see the same bad characters.   “pensylvanica,”

If I get rid of the smart quotes, it works fine.   Unfortunately, Filemaker does not allow me to search for them and I have to export the records to see the problem.

Is there some setting that I am missing?  I tried some of the encode and decode tags, but that made no difference.

Liz


Elizabeth K. Quigg
Education Technology Specialist

Education Office
Fermi National Accelerator Laboratory
630 840 2631 office
ed.fnal.gov<http://ed.fnal.gov/>
[hidden email]<http://person@...>

Connect with us!
Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>





#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Smart Quotes

Brad Lindsay
This is a character encoding issue. Somewhere along the line the data is stored as either UTF-8 or Latin 1 but then Lasso reads it as the opposite. If you are using the "-host” parameter to connect to the database, try adding a -tableEncoding="utf8" or a -tableEncoding="latin1" parameter to the array, and see if that makes any difference.

Brad

On July 8, 2015 at 4:06:30 PM, Elizabeth K Quigg ([hidden email]) wrote:

> I have a Filemaker database that I have updated through many versions of Filemaker and  
> Lasso. I am working on a development version of Lasso 9.2 on Windows 2012 and Filemaker  
> 13 on a separate Windows server and I have noticed some of my fields with smart quotes are  
> displaying incorrectly in some systems, but not all (e.g., my MacBook Air with Mountain  
> Lion and my colleagues iMac with Mavericks, a Windows system work fine, but my iMac with  
> Mountain Lion fails. When I access it with Lasso 8.6 on Windows 2008 and Filemaker 13 on  
> my iMac with Mountain Lion, it looks fine. My colleague with Windows has the problem with  
> the Lasso 9 version, but not Lasso 8.6.
>  
> Lasso 9 - "��pensylvanica,"��
> Lasso 8.6 “pensylvanica,” - smart quotes look fine.
>  
> If I export the data from Filemaker and import it into Excel, I see the same bad characters.  
> “pensylvanica,â€
>  
> If I get rid of the smart quotes, it works fine. Unfortunately, Filemaker does not allow  
> me to search for them and I have to export the records to see the problem.
>  
> Is there some setting that I am missing? I tried some of the encode and decode tags, but  
> that made no difference.
>  
> Liz
>  
>  
> Elizabeth K. Quigg
> Education Technology Specialist
>  
> Education Office
> Fermi National Accelerator Laboratory
> 630 840 2631 office
> ed.fnal.gov
> [hidden email]
>  
> Connect with us!
> Facebook | Twitter  
>  
>  
>  
>  
>  
> #############################################################
>  
> This message is sent to you because you are subscribed to
> the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to:  
> Send administrative queries to  


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Smart Quotes

stevepiercy
In reply to this post by lizquigg
In FMP, try using a double-quoted literal string to search for
smart quotes, I think "”" is the syntax.

In FMP > File > File Options > Text, uncheck "Use smart quotes".

In Lasso 9, your files should not have a BOM, which is a change
from Lasso 8.

You can do some tests for encoding of smart quotes in a sample
file and compare between FM and MySQL to see whether the
encoding borkage is in the Lasso datasource connector.

     '“smart quotes” aren't very smart'
     '<br>'
     '<h1>FileMaker</h1>'
     // inline to FM to return a record with smart quotes
     inline(...stuff...) => {^
         'action_statement: ' + action_statement
         '<br>'
         records => {^
             'myfield: ' +field('myfield')
             '<br>'
         ^}
     ^}

     '<h1>MySQL</h1>'
     // inline to MySQL to return a record with smart quotes
     inline(...stuff...) => {^
         'action_statement: ' + action_statement
         records => {^
             'myfield: ' +field('myfield')
             '<br>'
         ^}
     ^}

--steve


On 7/8/15 at 8:06 PM, [hidden email] (Elizabeth K Quigg) pronounced:

>I have a Filemaker database that I have updated through many
>versions of Filemaker  and Lasso.  I am working on a
>development version of Lasso 9.2 on Windows 2012 and Filemaker
>13 on a separate Windows server and I have noticed some of my
>fields with smart quotes are displaying incorrectly in some
>systems, but not all (e.g., my MacBook Air with Mountain Lion
>and my colleagues iMac with Mavericks, a Windows system work
>fine, but my iMac with Mountain Lion fails.   When I access it
>with Lasso 8.6 on Windows 2008 and Filemaker 13 on my iMac with
>Mountain Lion, it looks fine.  My colleague with Windows has
>the problem with the Lasso 9 version, but not Lasso 8.6.
>
>Lasso 9 -  "��pensylvanica,"��
>Lasso 8.6  “pensylvanica,”  - smart quotes look fine.
>
>If I export the data from Filemaker and import it into Excel, I
>see the same bad characters.   “pensylvanica,”
>
>If I get rid of the smart quotes, it works fine.  
>Unfortunately, Filemaker does not allow me to search for them
>and I have to export the records to see the problem.
>
>Is there some setting that I am missing?  I tried some of the
>encode and decode tags, but that made no difference.
>
>Liz
>
>
>Elizabeth K. Quigg
>Education Technology Specialist
>
>Education Office
>Fermi National Accelerator Laboratory
>630 840 2631 office
>ed.fnal.gov<http://ed.fnal.gov/>
>[hidden email]<http://person@...>
>
>Connect with us!
>Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>
>
>
>
>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Soquel, CA
<[hidden email]>               <http://www.StevePiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Smart Quotes

Bil Corry-3
In reply to this post by lizquigg
The diamond question mark is an UTF-8 symbol that means there's an illegal
byte sequence in the string.  So in L9, you're viewing a page that's sent
in UTF-8.  However, the underlying bytes are either not in UTF-8 but
accepted as if they were, or they are in UTF-8 but are being interpreted as
something other than UTF-8 then "converted" to UTF-8.

See if your L8 page connected to your L9 datasource still works.  And try
connecting L9 to your L8 datasource.  That will tell you if the issue is at
Lasso or the database.

- Bil

On Wed, Jul 8, 2015 at 10:06 PM, Elizabeth K Quigg <[hidden email]> wrote:

> I have a Filemaker database that I have updated through many versions of
> Filemaker  and Lasso.  I am working on a development version of Lasso 9.2
> on Windows 2012 and Filemaker 13 on a separate Windows server and I have
> noticed some of my fields with smart quotes are displaying incorrectly in
> some systems, but not all (e.g., my MacBook Air with Mountain Lion and my
> colleagues iMac with Mavericks, a Windows system work fine, but my iMac
> with Mountain Lion fails.   When I access it with Lasso 8.6 on Windows 2008
> and Filemaker 13 on my iMac with Mountain Lion, it looks fine.  My
> colleague with Windows has the problem with the Lasso 9 version, but not
> Lasso 8.6.
>
> Lasso 9 -  "��pensylvanica,"��
> Lasso 8.6  “pensylvanica,”  - smart quotes look fine.
>
> If I export the data from Filemaker and import it into Excel, I see the
> same bad characters.   “pensylvanica,â€
>
> If I get rid of the smart quotes, it works fine.   Unfortunately,
> Filemaker does not allow me to search for them and I have to export the
> records to see the problem.
>
> Is there some setting that I am missing?  I tried some of the encode and
> decode tags, but that made no difference.
>
> Liz
>
>
> Elizabeth K. Quigg
> Education Technology Specialist
>
> Education Office
> Fermi National Accelerator Laboratory
> 630 840 2631 office
> ed.fnal.gov<http://ed.fnal.gov/>
> [hidden email]<http://person@...>
>
> Connect with us!
> Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<
> http://twitter.com/FermilabEd>
>
>
>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Smart Quotes

lizquigg
In reply to this post by lizquigg
I have a Filemaker database that I have updated through many versions of Filemaker  and Lasso.  I am working on a development version of Lasso 9.2 on Windows 2012 and Filemaker 13 on a separate Windows server and I have noticed some of my fields with smart quotes are displaying incorrectly in some systems, but not all (e.g., my MacBook Air with Mountain Lion and my colleagues iMac with Mavericks, a Windows system work fine, but my iMac with Mountain Lion fails.   When I access it with Lasso 8.6 on Windows 2008 and Filemaker 13 on my iMac with Mountain Lion, it looks fine.  My colleague with Windows has the problem with the Lasso 9 version, but not Lasso 8.6.

Lasso 9 -  "��pensylvanica,"��
Lasso 8.6  “pensylvanica,”  - smart quotes look fine.

If I export the data from Filemaker and import it into Excel, I see the same bad characters.   “pensylvanica,”

If I get rid of the smart quotes, it works fine.   Unfortunately, Filemaker does not allow me to search for them and I have to export the records to see the problem.

Is there some setting that I am missing?  I tried some of the encode and decode tags, but that made no difference.

Liz


Elizabeth K. Quigg
Education Technology Specialist

Education Office
Fermi National Accelerator Laboratory
630 840 2631 office
ed.fnal.gov<http://ed.fnal.gov/>
[hidden email]<http://person@...>

Connect with us!
Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>
Elizabeth K. Quigg
Education Technology Specialist

Education Office
Fermi National Accelerator Laboratory
630 840 2631 office
ed.fnal.gov<http://ed.fnal.gov/>
[hidden email]<http://person@...>

Connect with us!
Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>





#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Smart Quotes

Carl Ketterling
Liz,

Probably not what you were expecting on this list, but here are some options
that may help:
* You CAN search for smart quotes.  I did a search using this text: "\”" and
was able to find all closing double smart quotes in my database.  I could
then use a script and calculation to replace them with regular quotes.
* Several posts I found using Google suggested adding a Script Trigger for a
layout based on OnObjectModify that would search for and replace smart
quotes (to keep them from being in your database in the first place).

I remember having a similar problem when I moved to Lasso 9, but my memory
isn’t as good as it once was.  Your problem could be related to one I
experienced when upgrading to Lasso 9.3.  If that’s the case, you may be
able to use Lasso 9.2.x and not experience this problem.  Here’s what I’d
reported:
http://lasso.2283332.n4.nabble.com/Lasso-9-3-Yosemite-and-FileMaker-woes-tp4
643597p4643607.html

Hope this helps.

Carl



From: Elizabeth K Quigg <[hidden email]>
Reply-To: <[hidden email]>
Date: Mon, 13 Jul 2015 22:30:49 +0000
To: "[hidden email]" <[hidden email]>
Subject: Smart Quotes

I have a Filemaker database that I have updated through many versions of
Filemaker  and Lasso.  I am working on a development version of Lasso 9.2 on
Windows 2012 and Filemaker 13 on a separate Windows server and I have
noticed some of my fields with smart quotes are displaying incorrectly in
some systems, but not all (e.g., my MacBook Air with Mountain Lion and my
colleagues iMac with Mavericks, a Windows system work fine, but my iMac with
Mountain Lion fails.   When I access it with Lasso 8.6 on Windows 2008 and
Filemaker 13 on my iMac with Mountain Lion, it looks fine.  My colleague
with Windows has the problem with the Lasso 9 version, but not Lasso 8.6.

Lasso 9 -  "��pensylvanica,"��
Lasso 8.6  “pensylvanica,”  - smart quotes look fine.

If I export the data from Filemaker and import it into Excel, I see the same
bad characters.   “pensylvanica,”

If I get rid of the smart quotes, it works fine.   Unfortunately, Filemaker
does not allow me to search for them and I have to export the records to see
the problem.

Is there some setting that I am missing?  I tried some of the encode and
decode tags, but that made no difference.

Liz


Elizabeth K. Quigg
Education Technology Specialist

Education Office
Fermi National Accelerator Laboratory
630 840 2631 office
ed.fnal.gov<http://ed.fnal.gov/>
[hidden email]<http://person@...>

Connect with us!
Facebook <http://www.facebook.com/FermilabEd>  |
Twitter<http://twitter.com/FermilabEd>
Elizabeth K. Quigg
Education Technology Specialist

Education Office
Fermi National Accelerator Laboratory
630 840 2631 office
ed.fnal.gov<http://ed.fnal.gov/>
[hidden email]<http://person@...>

Connect with us!
Facebook <http://www.facebook.com/FermilabEd>  |
Twitter<http://twitter.com/FermilabEd>




############################################################# This message
is sent to you because you are subscribed to  the mailing list Lasso
[hidden email] Official list archives available at
http://www.lassotalk.com To unsubscribe, E-mail to:
<[hidden email]> Send administrative queries to
<[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Smart Quotes

stevepiercy
In reply to this post by lizquigg
Is there an echo?
http://lasso.2283332.n4.nabble.com/Smart-Quotes-tt4643914.html

Maybe check your spam filters for replies from the list?

--steve


On 7/13/15 at 10:30 PM, [hidden email] (Elizabeth K Quigg) pronounced:

> I have a Filemaker database that I have updated through many versions of Filemaker  and
> Lasso.  I am working on a development version of Lasso 9.2 on Windows 2012 and Filemaker
> 13 on a separate Windows server and I have noticed some of my fields with smart quotes are
> displaying incorrectly in some systems, but not all (e.g., my MacBook Air with Mountain
> Lion and my colleagues iMac with Mavericks, a Windows system work fine, but my iMac with
> Mountain Lion fails.   When I access it with Lasso 8.6 on Windows 2008 and Filemaker 13 on
> my iMac with Mountain Lion, it looks fine.  My colleague with Windows has the problem with
> the Lasso 9 version, but not Lasso 8.6.
>
> Lasso 9 -  "��pensylvanica,"��
> Lasso 8.6  “pensylvanica,”  - smart quotes look fine.
>
> If I export the data from Filemaker and import it into Excel, I see the same bad
> characters.   “pensylvanica,”
>
> If I get rid of the smart quotes, it works fine.   Unfortunately, Filemaker does not allow
> me to search for them and I have to export the records to see the problem.
>
> Is there some setting that I am missing?  I tried some of the encode and decode tags, but
> that made no difference.
>
> Liz
>
>
> Elizabeth K. Quigg
> Education Technology Specialist
>
> Education Office
> Fermi National Accelerator Laboratory
> 630 840 2631 office
> ed.fnal.gov<http://ed.fnal.gov/>
> [hidden email]<http://person@...>
>
> Connect with us!
> Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>
> Elizabeth K. Quigg
> Education Technology Specialist
>
> Education Office
> Fermi National Accelerator Laboratory
> 630 840 2631 office
> ed.fnal.gov<http://ed.fnal.gov/>
> [hidden email]<http://person@...>
>
> Connect with us!
> Facebook <http://www.facebook.com/FermilabEd>  |  Twitter<http://twitter.com/FermilabEd>
>
>
>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Soquel, CA
<[hidden email]>               <http://www.StevePiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>